SQL查询将数据按字段（2017081511:34:05）进行按月分组

$sql="select date_format(me_createTime,‘%Y-%m‘)as create_month,count(me_id) as me_num from {$SETTING[‘db‘][‘prefix‘]}member where me_state in(1,2) and sm_id=‘$sm_id‘ group by date_format(me_createTime,‘%Y-%m‘) order by date_format(me_createTime,‘%Y-%m‘) desc";