select distinct l.date,IFNULL(new,0)
from login l
left join (
select min_date,count(*) new
from (
select min(date) min_date
from login
group by user_id
) t
group by min_date
) t2
on l.date=t2.min_date
order by l.date;