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