jiaxincui/closure-table

tree.php

<?php
    $menu = \App\Menu::find(1);
    $menu->getDescendantsAndSelf();

    $menu = \App\Menu::find(3);
    $menu->getAncestorsAndSelf();

    $menu = \App\Menu::find(1);
    dd($menu->getTree());



/*    \App\Menu::insert(['id' => 1, 'name'=>'name1']);
    \App\CategoryPath::insert(['ancestor_id' => 1, 'category_id'=>1, 'level' => 0]);
    $page = \App\Menu::find(1);
    $page->makeRoot();
    $newChild = \App\Menu::create(['id' => 2, 'name'=>'name2', 'parent' => 1]);
    $newChild->name = 'name2';
    $newChild->moveTo(1);

    $newChild = \App\Menu::create(['id' => 4, 'name'=>'name4', 'parent' => 2]);
    $newChild->name = 'name4';
    $newChild->moveTo(2);
*/
    $page = \App\Menu::find(2);
    $newChild = new \App\Menu(['id' => 5, 'name'=>'name5', 'parent' => 2]);
    $page->addChild($newChild);