select count(ID) as counts, USER_ID,GROUP_ID,DATE_FORMAT(PTIME, '%Y-%m') AS timer FROM FILE_INFO GROUP BY timer,USER_ID,GROUP_ID;