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