select date(order_time)order_date,o.user_id,count(order_id)order_nums,vip
from order_tb o 
join uservip_tb u
using(user_id)
group by date(order_time),o.user_id,vip
having count(order_id) >1
order by order_nums desc;
我终于想起来用having而不是where了哈哈