select date(o.order_time) as order_date, o.user_id, count(o.order_price) as order_nums, u.vip
from order_tb o
join uservip_tb u using(user_id)
group by user_id, order_date
having count(o.order_price) > 1