select distinct date_format(o.order_time,'%Y-%m-%d') as order_date,
    o.user_id as user_id,
    count(o.order_time) as order_nums,
    u.vip as vip 
from order_tb as o 
    left join uservip_tb as u on o.user_id = u.user_id 
group by o.user_id, order_date
having order_nums > 1