子查询:where子句里套一个查询 查询在西安服里 游玩过的玩家 的昵称 SELECT p.`name` FROM players as p WHERE `id` = (SELECT `p_id` FROM `server` as s WHERE s.`name`='西安服')