select ut.vip,sum(case when order_price is not null then order_price else 0 end) as order_total
from uservip_tb ut left join  
order_tb ot  on
ot.user_id=ut.user_id
group by ut.vip
order by order_total desc;