select
    vip,
    sum(if (order_price, order_price, 0)) order_total
from
    uservip_tb ut
    left join order_tb ot on ut.user_id = ot.user_id
group by
    vip
order by
    order_total desc