2 added 21 characters in body
source | link

As a schema:

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

As a schema:

SELECT name, 
       GROUP_CONCAT(CONCAT(id, ':', status_name, '(', cnt, ')')) AS all
FROM ( SELECT name, 
              id, 
              status_name, 
              COUNT(status_name) AS cnt
       FROM source_tableset
       GROUP BY name, 
                id, 
                status_name ) AS subquery
GROUP BY name

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
1
source | link

As a schema:

SELECT name, 
       GROUP_CONCAT(CONCAT(id, ':', status_name, '(', cnt, ')')) AS all
FROM ( SELECT name, 
              id, 
              status_name, 
              COUNT(status_name) AS cnt
       FROM source_tableset
       GROUP BY name, 
                id, 
                status_name ) AS subquery
GROUP BY name