SELECT u.vip    , COALESCE(SUM(o.order_price) ,0)  AS order_total

FROM order_tb AS o RIGHT JOIN uservip_tb AS u ON o.user_id = u.user_id

GROUP BY u.vip

ORDER BY order_total DESC