mysql分组查询时如何给每一组加一个自增字段

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