分享一个用 ORM 写无限极分类的帖子, 大佬请跳过.

实现无限极分类,运用场景为:树目录/部门分类/动态菜单等

直接上代码:
模型:

 protected $table = 'menu';//自定义表名（protected $table）
    protected $primaryKey = 'id';//主键字段，默认为id
    public $timestamps = false;//如果数据表中没有created_at和updated_id字段，则$timestamps则可以不设置，默认为true

    public function childrenModule()
    {
        return $this->hasMany(Menu::class,'fatherId','id');
    }

    public function children()
    {
        return $this->childrenModule()->with('children');
    }

控制层:

  $data = Menu::where(['fatherId' => 0, 'isDel' => 0])
            ->select('id', 'title', 'href', 'fontFamily', 'icon', 'spread', 'isCheck')
            ->with(['children:id,fatherId,title,href,fontFamily,icon,spread'])
            ->get();

最终实现效果:

{
    "id": 10,
    "title": "框架管理",
    "href": "sys/pages/frame/index",
    "fontFamily": "ok-icon",
    "icon": "",
    "spread": 0,
    "isCheck": 0,
    "children": [
        {
            "id": 11,
            "fatherId": 10,
            "title": "路由管理",
            "href": "",
            "fontFamily": "ok-icon",
            "icon": "&#xe6a3",
            "spread": 0,
            "children": [
                {
                    "id": 12,
                    "fatherId": 11,
                    "title": "路由管理1",
                    "href": null,
                    "fontFamily": "ok-icon",
                    "icon": "&#xe6a3",
                    "spread": 0,
                    "isCheck": 0,
                    "isDel": 1,
                    "children": []
                },
                {
                    "id": 13,
                    "fatherId": 11,
                    "title": "路由管理2",
                    "href": null,
                    "fontFamily": "ok-icon",
                    "icon": "&#xe6a3",
                    "spread": 0,
                    "isCheck": 0,
                    "isDel": 1,
                    "children": []
                }
            ]
        }
    ]
}

本作品采用《CC 协议》，转载必须注明作者和本文链接