select
    vip,
    sum(ifnull (order_price, 0)) order_total
from
    order_tb
    right join uservip_tb using (user_id)
group by
    vip
order by
    order_total desc