select order_date
,a.user_id
,order_nums
,vip 
from 
(
	select user_id
	,date_format(order_time,'%Y-%m-%d') order_date
	,count(order_id) order_nums
	from order_tb
	group by 1,2
	having order_nums > 1
)a
join uservip_tb
on a.user_id = uservip_tb.user_id
order by order_nums desc