今天在大佬处学到了一句sql解了我的迷惑贼几把开心

select * from t_parent_student inner join t_student where stuid = stuid and parentid = ?

我自己写的

select c.name,s.chnName,ps.stuId,ps.role,ps.id from t_parent_student ps inner join t_student s inner join t_clazz c 
where ps.stuId = s.stuId and ps.clazzId=c.clazzId and parentId = 2;