select date(order_time) as order_date
,user_id
,count(*) as order_nums
,vip
from order_tb join uservip_tb using(user_id)
group by order_date,user_id
having order_nums > 1 
order by order_nums desc