select distinct(login.date) , if(c is null , 0 , c)from
login left join
(select date , count(1) c from
(select user_id , min(date) date from login group by user_id)temp
group by date)temp2 on login.date = temp2.date