select vip,sum(price) as order_total
from
(
select u.user_id, vip,
ifnull(order_price,0) as price
from uservip_tb as u
left join 
(
select user_id,order_price from order_tb
) as o
on u.user_id = o.user_id
) as t1
group by  vip
order by order_total desc