select date(order_time) as order_date,
user_id,
count(*)
as order_nums,
vip
from order_tb
left join uservip_tb
using (user_id)
group by
order_date,
user_id
having(order_nums) > 1