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