select vip 
,ifnull(sum(order_price),0) order_total
from order_tb
right join uservip_tb
on order_tb.user_id = uservip_tb.user_id 
group by 1
order by order_total desc