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

指定左或右连接时，如果另一侧没有值时会设为null