select 
    u.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