mysql查询结果增加序列号排序

SELECT (@rank :=@rank + 1) AS rank,temp.* FROM ( (SELECT u.* FROM users u ORDER BY u.integral DESC LIMIT 0,5) temp, (SELECT @rank := 0) b )