users table
username | parent


shop_items
itemid     | parentitem


shop_order_head
orderid | username  |date | orderstatus


shop_order_row
orderid | itemid | quantity


question:
get shop_order_row.quantity per item(including children) boss that has been ordered and has orderstatus 2.