yii2 parent_id orqali join qilishda muammo

Question

Assalomu alaykum. Menda  ta atblitsa bor: Unda id, title, content, parent_id bor. Shu tablitsadagi parent_id ni id ga bog'lab chiqarmoqchiman. Shuni qande qilsam bo'ladi?

Masalan:

[0] => [
'name' => 'Name',
'content' => 'Content'
'childs' => [
...
]

Modelda hasMany ga:

return $this->hasMany(ForumSections::className(), ['parent_id' => 'id'])->from(ForumSections::tableName() . 'childs');

va

return $this->hasMany(ForumSections::className(), ['parent_id' => 'id']);

yozib ko'rdim bo'lmadi.

Men controllerda

$result = ForumSections::find()->???join...

kabi olmoqchiman balki shunda xatolik bordur?

Answer 1

$sections = ForumSections::find()->indexBy('id')->where(['status' => 1])->asArray()->all();

protected function getSectionsTree($sections)
{
    $result = [];
    foreach ($sections as $id=>&$node) {
        if (!$node['parent_id'])
            $result[$id] = &$node;
        else
            $sections[$node['parent_id']]['childs'][$node['id']] = &$node;
    }

    return $result;
}