select
    date(order_time) as order_date,
    o.user_id,
    count(o.order_id) as order_nums,
    u.vip
from
    order_tb o left join uservip_tb u
    on o.user_id = u.user_id
group by o.user_id,order_date
having order_nums > 1
order by order_nums desc
;