MANY_MANY，中间表有条件如何查询？

International Chinese
1

有如下三个表，它们是many to many 关系，

Users(id, username, password)

Projects(id, name)

ProjectsUsers(user_id, project_id, status)，

有如下数据

Users表，

(1, "user1", "user1")

(2, "user2", "user2")

Projects表，

(1, "project1")

(2, "project2")

ProjectsUsers表，

(1, 1, 1)

(2, 1, 0)

我在查询Project的时候，如何查询ProjectsUsers表中status=1的所有记录？

2

Project::model()->findAll(array(

'join'=>'INNER JOIN ProjectsUsers ON ProjectsUsers.status=1',

));

3

感谢强哥的回答，Yii的结构还真复杂啊～ B)