Laravel 中 Eloquent ORM 关联注意事项

当Model中定义的关系除外键还有其他的筛选条件时，我们会在关系函数中额外加where或者其他筛选语句：

class Client extends Model{

    public function followingProject() {
	    	return $this->hasMany(Project::class)->where("project_status_id", "=", 1);
    }
    // ... 
}

他会由框架转化为SQL语句，其中 projects.client_id in (?) 为 ROM 关系定义的限制条件，project_status_id = 1 为额外的条件

select* from `projects` where `project_status_id` = 1 and `projects`.`client_id` in (?)

然而如果额外条件需要用到多个语句来描述时，一定要用闭包函数或者原生语句来定义需要的筛选条件！

正确示范:

	public function declaredProject() {
		// 原生语句
		return $this->hasMany(Project::class)->whereRaw("(project_status_id in (4,6,8) or published = 1)");
		
		// 闭包函数
		return $this->hasMany(Project::class)->where(function ($q) {
			$q->whereIn("project_status_id", [4,6,8])->orWhere("published", 1);
		});
	}

解析SQL为:
select * from projects where (project_status_id in (4, 6, 8) or published = 1) and projects.client_id in (?)

错误示范：

	public function declaredProject() {
		return $this->hasMany(Project::class)->whereIn("project_status_id", [4,6,8])->orWhere("published", 1);
	}

解析SQL为：
select * from projects where project_status_id in (4, 6, 8) or published = 1 and projects.client_id in (?)