select count(*) from members as m where date(CONVERT_TZ(m.created_at,'GMT','America/Los_Angeles')) = date(CONVERT_TZ(now(),'GMT','America/Los_Angeles'))