擅长:python、mysql、java
<p>可以使用连接</p>
<pre><code>db.session.query(StudentCollegeMappingModel, Student, College)
.join(StudentCollegeMappingModel)
.join(Student)
.join(College)
.filter(StudentCollegeMappingModel.student_id == Student.id, StudentCollegeMappingModel.college_id==college_id,Student.deleted==False, College.deleted==False)
).all()
</code></pre>