mysql:
select count(*) as cnt, d from (select date_format(create_time,'%%Y/%%m/%%d') as d,user_id from note_digg where create_time between curdate() - interval 90 day and curdate() group by d, user_id) q group by d order by d