select
vip
,if(sum(order_price) is not null, sum(order_price), 0) 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