with t2 as(
    select date from login group by date
)
select date,sum(if(first_date = date,1,0))
from t2 left join login using(date) left join(
    select min(date) first_date,user_id
    from login
    group by user_id
)t1 using(user_id)
group by date
order by date