SELECT
    DATE(a.order_time) AS order_date,
    a.user_id,
    COUNT(*) AS order_nums,
    b.vip
FROM order_tb AS a
INNER JOIN uservip_tb AS b
    ON (a.user_id = b.user_id)
GROUP BY DATE(a.order_time), a.user_id
HAVING order_nums > 1
ORDER BY order_nums DESC;