YII2如何使用hasMany关系获取多层次关系中的数据

Question

我得到了3个表:

网络、公司、部门

网络

<表类>id名称tbody><<tr>1Network12Network2

你可以这样称呼它:

$results = Network::find()
->joinWith('company')
->joinWith('company.department')
->where(['network.id' => 1])
->all();

和你的foreach:

if($results){
foreach($results as $result){
if($companies = $result->company){ 
foreach($companies as $company){ //foreach you companies attached to network One
if($departments = $company->department){
foreach($departments as $department){ //foreach you departments attached to every company
echo $department->name.' (Company: '.$company->name.')';
}
}
}
}
}
}

我认为另一种方式更好

$departments = Department::find()
->leftJoin('company', 'company.id = department.company_id')
->where('company.network_id = 1')
->all();

这取决于你需要展示什么数据。

p。在你的Department中必须与Company有关系并且可以使用它