BelongsToMany 独立子关系 - Laravel/Eloquent

Question

模型结构：

FoodCategory - hasMany：Food

Food -belongsToMany：AccessoryGroup |属于：FoodCategory

AccessoryGroup - hasMany：Accessory | belongsToMany：Food

Accessory-belongsTo：AccessoryGroup

$foodCategories = FoodCategory
  ::with([
   'foods',
   'foods.accessory_groups',
   'foods.accessory_groups.accessories',
  ])
  ->get();

$foodCategories->each(function($foodCategory) {
  $foodCategoryId = $foodCategory->id;
  $foodCategory->foods->each(function($food) use( $foodCategoryId ) {
    $food->accessory_groups->each(function($accessoryGroup) use( $foodCategoryId ) {

      $accessoryGroup->accessories->each(function($accessory) use( $foodCategoryId ) {

        // accessory - not unique by different food grandparent realation
        $accessory->parent_food_category_id = $foodCategoryId;

      });

    });
  });
});

问题是当我设置$accessory->parent_food_category_id = $foodCategoryId; 最后一个相同配件覆盖“所有配件”的parent_food_category_id值（具有相同的id） - （不同的食物祖父母）。

是否可以轻松“克隆”belongsToMany 关系（在本例中是accessory_groups）。与您更改其子项 (accessory) 相比，不要更改所有相同的 accessories （具有相同的 id）。

需要优化的解决方案。不要为每种食物调用单独的sql -> accessory_group关系（此问题的解决方案之一）

Answer 1

我的解决方案（使用复制模型方法）

$foodCategories->each(function($foodCategory) {
  $foodCategoryId = $foodCategory->id;
  $foodCategory->foods->each(function($food) use( $foodCategoryId ) {
    $food->accessory_groups->each(function($accessoryGroup) use( $foodCategoryId ) {

      $accessoryGroup->accessories->each(function($accessory, $index) use( $foodCategoryId, $accessoryGroup ) {
    
    // Create clone
        $accessoryClone = $accessory->replicate();
        $accessoryClone->parent_food_category_id = $foodCategoryId;
    
    // OVERRIDE existing accessory with cloned
        $accessoryGroup->accessories[$index] = $accessoryClone;

      });

    });
  });
});