Help getting mysql info via Smarty

[stuntnmore]

Hello, i need a mysql query that will get pending orders status with client name and payment status of the order

 

This is what i have so far..

 

SELECT `id`, `status` FROM `tblorders` WHERE tblorders.status='active' ORDER BY `userid` ASC LIMIT 0,5"

 

I want it to also get the username of the client and the payment of it and if possible the product that was purchased as well.

 

All help greatly appreciated thank you