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