SELECT
a.group_id,
a.name,
IF(
IFNULL(@group_ids ,(@group_ids := a.group_id)) = group_id ,
(@i := @i + 1),
(@i := 1 AND ( @group_ids := a.group_id))
) AS rowNo
FROM test.test a ,
(SELECT @i := 0,@group_ids := NULL ) i ;
查询结果按group_id 分组,每一组增加一个排序字段 rowNo