这个也能过^_^

select *
from
(select user_id, min(date) day
from login
group by user_id) a
join
(select distinct date
from login) b
on a.day=b.date
where user_id in (select user_id from (select user_id, date_add(date, interval 1 day) from login) t)