mysql按排序查询数据,返回数据行数

select a.*,
        (@rownum := @rownum + 1) rownum
  from (select u.user_id,
               u.user_name
          from t_user u
         where and u.user_id = 1
         order by u.user_id asc) a,
       (select (@rowNum := 0)) b