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