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