SELECT name, GROUP_CONCAT(realname) as realname1, sum(gs) as gs 
FROM (
SELECT pl.name, p1.code, u.realname, s.ssgs
  , SUM( zt.consumed ) AS 'gs', date_format(now(), '%Y-%m') as yf,
  ((DAY(now())+WEEKDAY(now()-INTERVAL DAY(now()) DAY)) DIV 7) as jz
FROM zt_taskestimate zt
    INNER JOIN zt_task t ON t.id = zt.task
    LEFT JOIN zt_project p ON p.id = t.project
    LEFT JOIN zt_user u ON u.account = zt.account
    LEFT JOIN zt_skunk s ON u.realname = s.name
    LEFT JOIN zt_projectproduct p2 ON p2.product = p1.id
    LEFT JOIN zt_product p1 ON p2.product = p1.id
WHERE date>= DATE_SUB(now(), INTERVAL 7 DAY)
GROUP BY p1.name, u.realname, u.account
) cb_view

   GROUP BY code, name ORDER BY gs desc