SELECT department.value, room.id, room.value
FROM department
LEFT JOIN building ON department.id=building.department_id
LEFT JOIN room ON building.id=room.building_id
WHERE department.id = 7
class Department extends \yii\db\ActiveRecord {
/**
* @return \yii\db\ActiveQuery
*/
public function getBuildings() {
return $this->hasMany(Building::className(), ['department_id' => 'id']);
}
// ...
}var_dump($department->buildings);class Building extends \yii\db\ActiveRecord {
/**
* @return \yii\db\ActiveQuery
*/
public function getDepartment() {
return $this->hasOne(Department::className(), ['id' => 'department_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getRooms() {
return $this->hasMany(Room::className(), ['building_id' => 'id']);
}
// ...
}var_dump($building->department);
var_dump($building->rooms);class Room extends \yii\db\ActiveRecord {
/**
* @return \yii\db\ActiveQuery
*/
public function getBuilding() {
return $this->hasOne(Building::className(), ['id' => 'building_id']);
}
// ...
}var_dump($room->building);
Средний
Средний
