select
        utb.vip,
        sum(if(order_price is null,0,order_price)) as order_total
from
        uservip_tb as utb
left join 
        order_tb as otb
on 
        utb.user_id = otb.user_id
group by 
        utb.vip
order by 
        order_total desc