$SQL="select s. *, m.g roupname from think_user s left join think_group m on s.g roup=m.i d order by m.g roupname". The limit, "". $Page - & gt; FirstRow. ', '. $Page - & gt; ListRows;