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

COALESCE(字段,0）确保不出现null值，若出现会用0代替