2017-05-15 22:24
浏览 63


How can I create a nested list of categories in Laravel?

I want to create something like this:

  • --- Php
  • ------ Laravel
  • --------- Version
  • ------------ V 5.7
  • --- Python
  • ------ Django
  • --- Ruby
  • ..........

My table's fields are:

id | name | parent_id

If I have to add another column like depth, please tell me.

I am using this following code, but I think it is not the best solution for creating nested-list of categories besides, I can not pass this function to my view.

function rec($id)
     $model = Category::find($id);
     foreach ($model->children as $chield) rec($chield->id);
     return $model->all();

function main () {
    $models = Category::whereNull('parent_id')->get();
    foreach ($models as $parent) return rec($parent->id);
  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

4条回答 默认 最新

  • doujilou3903 2017-05-15 22:30

    You can make a self-referential model:

    class Category extends Model {
        public function parent()
            return $this->belongsTo('Category', 'parent_id');
        public function children()
            return $this->hasMany('Category', 'parent_id');

    and make a recursive relation:

    // recursive, loads all descendants
    public function childrenRecursive()
       return $this->children()->with('childrenRecursive');

    and to get parents with all their children:

    $categories = Category::with('childrenRecursive')->whereNull('parent')->get();

    Lastly you need to just iterate through the children until children is null. There can definitely be some performance issues with this if you are not careful. If this is a fairly small dataset that you plan to remain that way it shouldn't be an issue. If this is going to be an ever growing list it might make sense to have a root_parent_id or something to query off of and assemble the tree manually.

    解决 无用
    打赏 举报
  • 查看更多回答(3条)

相关推荐 更多相似问题