select u.vip as vip, coalesce(sum(o.order_price),0) as order_total from uservip_tb u left join order_tb o on u.user_id=o.user_id group by u.vip order by order_total desc