SELECT
m.id,
m.admin_user,
m.login_count,
m.last_ip,
m.last_time,
l.level_name
FROM
cms_manage m,
cms_level l
WHERE
l.level = m.level
ORDER BY
m.id ASC
LIMIT
m.id,
m.admin_user,
m.login_count,
m.last_ip,
m.last_time,
l.level_name
FROM
cms_manage m,
cms_level l
WHERE
l.level = m.level
ORDER BY
m.id ASC
LIMIT
0,20
这个是查询管理员等级的表,取别名的方式吧。。。