select date_format(mb_email_certify, '%Y%m') as date, count(*) from g4_member group by date_format(mb_email_certify, '%Y%m') order by date asc;

select date_format(mb_email_certify, '%Y') as date, count(*) from g4_member group by date_format(mb_email_certify, '%Y') order by date asc;