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