MySQL, would like to get both a field and a count inside GROUP_CONCAT
As a schema:

SELECT name, 
       GROUP_CONCAT(CONCAT(status_id, ':', status_name, '(', status_cnt, ')')) AS all
FROM ( SELECT name, 
              status_id, 
              status_name, 
              COUNT(status_name) AS status_cnt
       FROM source_tableset
       GROUP BY name, -- first level GROUP BY and counting
                status_id, 
                status_name ) AS subquery
GROUP BY name -- second level GROUP BY and group concatenation