(一)两个字段的排序查询 select * from (select * from admin order by admin_id asc) as t order by t.admin_group_id asc;