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