select l1.date,sum(l1.date=l2.date) as new
from login l1
    left join (
        select user_id	,min(date) as date
        from login 
        group by user_id
    ) l2 on l1.user_id=l2.user_id
group by l1.date