[Complex MySQL Query Help]

I have 3 tables:

 

member_items id (not important), item_id (= items.id), owner_id (= members.id), amount

items id, name, price

members id, username

 

What I am trying to do here is add up all of a users item values (amount * price) and sort users accordingly from most assets to least. I have started the query, but I don't really know where to go from here. At this point, it doesnt add all the items together, it just gets the last item found for each user

 

SELECT member_items.amount * items.price AS TOTAL, member_items.owner_id FROM member_items LEFT JOIN items ON member_items.item_id = items.id WHERE member_items.amount > 0 GROUP BY member_items.owner_id;

 

Thanks in advance.