Subquery returns more than 1 row表示子查询返回了多行数据 例如: select * from role where id=(select roleId from users_role where userId = 1) 解决方法 select * from role where id=ANY(select roleId from users_role where userId = 1)