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