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