一旦您有了新的列，此查询将为您提供所需的结果：

SELECT GROUP_CONCAT(Numbers) FROM table GROUP BY `group`

输出：

group_concat(numbers)
10,20,30
40,50
60

所以整个查询可以是：

SELECT GROUP_CONCAT(Numbers),
(SELECT IFNULL(SUM(group_generator), 0) FROM table1 t2 WHERE t2.id < table1.id) AS `group`
FROM table1
GROUP BY `group`

输出

group_concat(Numbers)   group
10,20,30                0
40,50                   1
60                      2

还可以使用存储过程生成此输出：

DELIMITER //
drop PROCEDURE if EXISTS groupit
//
create procedure groupit()
begin
   declare num int;
   declare numgroup varchar(1024) default '';
   declare gnum int default 0;
   declare pid int default 1;
   declare gg int;

   DECLARE CONTINUE HANDLER FOR NOT FOUND SET gg = -1;

   repeat
     select group_generator, Numbers  into gg, num from table2 where id=pid;
     if (gg >= 0) then
         set numgroup = concat(numgroup, if(numgroup='', '', ','), num);
         if (gg = 1) then
             select numgroup, gnum;
             set numgroup = '';
             set gnum = gnum + 1;
         end if;
     end if;
     set pid=pid+1;
   until gg = -1
   end repeat;
end
//
delimiter ;