SELECT
    DATE(order_time) AS order_date,
    user_id,
    COUNT(order_id) AS order_nums,
    vip
FROM order_tb
LEFT JOIN uservip_tb USING (user_id)
GROUP BY user_id,order_date,vip
HAVING order_nums > 1
ORDER BY order_nums DESC