SELECT u.user_id, u.point+COALESCE(total_cunsume,0)  AS point
FROM   uservip_tb AS u LEFT JOIN 
(
SELECT u.user_id ,SUM(o.order_price) AS total_cunsume
FROM  order_tb AS o  JOIN uservip_tb AS u ON u.user_id = o.user_id
WHERE o.order_price>100 
GROUP BY u.user_id 
) AS n ON u.user_id=n.user_id
WHERE  u.user_id IN (SELECT DISTINCT user_id FROM order_tb WHERE order_price>100 )
ORDER BY point DESC