mysql排序后直接生成排序序号 select users.*,@rank:=@rank + 1 AS rank_no from users,(SELECT @rank:= 0) b order by create_time desc;