select date_format(mb_datetime, '%Y-%m-%d')as vs_date ,Count(*) as cnt
from g5_member
where (mb_datetime between '2015-01-01' and '2016-02-23') and (mb_bccard=3) and(mb_ten!='Y')and(mb_lottecard!='Y') and mb_is_delete !=1
GROUP BY date_format(mb_datetime, '%Y-%m-%d')
결과값
vs_date cnt
'2016-02-05', '15'
'2016-02-06', '3'
'2016-02-07', '1'
'2016-02-09', '1'
'2016-02-10', '2'
'2016-02-11', '7'
'2016-02-12', '1'
'2016-02-16', '1'
여기서 없는날짜들은 0으로 표시하고싶은데 어떻게 query를 짜야하나요..