select 
t2.vip 
,if(sum(t1.order_price)>0,sum(t1.order_price),0) order_total
from order_tb t1
right join uservip_tb t2
on t1.user_id = t2.user_id
group by 1
order by 2 desc