select vip, ifnull(sum(b.order_price), 0) as order_total
from uservip_tb a left join order_tb b on a.user_id=b.user_id
group by vip
order by order_total desc