php - 如何获取三级分类(Category,SubCategory,SubCategoryThree)的数据并显示所选分类下的相关数据

Question

我有三个表。结构是:

1. categories

    id - integer

    name - string

2. sub_Categories

    id - integer

    category_id - integer

    name - string


3. sub_catergory_threes

    id - integer

    sub_Category_id - integer

    name- string

现在我想显示三个级别的类别，例如类别，当鼠标悬停在任何类别项目上时，显示该类别的子类别，当鼠标悬停在任何子类别项目上时，显示该子类别的 Sub_Categories_Three

im using laravel eloquent here are My Models

Category Model

public function subcategories(){
    return $this->hasMany('App\SubCategory');
}

SubCategory Model

public function subcategoriesthree(){
    return $this->hasMany('App\SubCategoryThree');
}

public function category(){
    return $this->belongsTo('App\Category');
}

SubCategoriesThree Model

public function subcategory(){
    return $this->belongsTo('App\SubCategory');
}

Answer 1

所以你可以像这样编辑你的模型:

子类别

public function subcategoriesthree(){
    return $this->hasMany('App\SubCategoryThree');
}

public function category(){
    return $this->belongsTo('App\Category', 'category_id');
}

子类别三

public function subcategory(){
    return $this->belongsTo('App\SubCategory', 'sub_Category_id');
}

在你的 Controller 中:

$categories = Category::with(['subcategories', 'subcategories.subcategoriesthree'])->get();

然后你可以 dd($categories) 并在 subcategories 下看到 subcategoriesthree。