select order_date
,user_id
,order_nums
,vip
from (select date(order_time) as order_date
,t.user_id
,t1.vip
,count(*) as order_nums
from order_tb t 
join uservip_tb t1 on t.user_id=t1.user_id
group by date(order_time),t.user_id,t1.vip
having order_nums>1) t