SELECT @rownum :=@rownum +1 AS rownum,USER.* FROM USER(表名) ,(SELECT @rownum :=0)r WHERE XXXXX (条件) ORDER BY XXX