左连接进行判断：
select a.date,count(b.date)
from login a
left join (select id,min(date) date from login group by user_id) b
on a.id=b.id
group by a.date