菜单多类别数组组合 Laravel 的 API 响应

Question

我正在尝试为我的 React js 和 Laravel 创建一个 API 作为后端。因此，对于菜单，我有类别、子类别和进一步的子类别。我需要将所有结果合并如下，

{

  "response": 200,

  "data": [

    {

      "id": 15,

      "name": "dfdfhdf rtuydf",

      "slug": "dfdfhdf-rtuydf",

      "subcategory": [

        {

            "sub_id": 15,

            "sub_name": "dfdfhdf rtuydf",

            "sub_slug": "dfdfhdf-rtuydf"

            "fsubcategory": [

              {

                "fsub_id": 15,

                "fsub_name": "dfdfhdf rtuydf",

                "fsub_slug": "dfdfhdf-rtuydf"

              },

              ...

            ]

        },

        ...

      ]

    },

    ....

  ]

}

我尝试使用下面的代码，但结果未按预期显示。

$list = Category::select('id', 'name', 'slug')->where(array('in_menu' => 1, 'status' => 1, 'deleted_at' => null))->orderBy('id', 'desc')->get();

$array = [];

foreach ($list as $category) {

        $sublist = Subcategory::select('id', 'name', 'slug')->where(array('category_id' => $category->id, 'status' => 1, 'deleted_at' => null))->orderBy('id', 'desc')->get();

        $first = array("id" => $category->id, "name" => $category->name, "slug" => $category->slug);

        array_push($array, array("category" => $first));

        foreach($sublist as $subcategory) {

            array_push($array, array("subcategory" => array("sub_id" => $subcategory->id, "sub_name" => $subcategory->name, "sub_slug" => $subcategory->slug)));

        }

}

return response()->json(['response' => 200, 'data' => $array]);

上述代码的结果是，

{

"response": 200,

"data": [

    {

    "category": {

        "id": 15,

        "name": "dfdfhdf rtuydf",

        "slug": "dfdfhdf-rtuydf"

    }

    },

    {

    "subcategory": {

        "sub_id": 6,

        "sub_name": "Test Subcategory 221",

        "sub_slug": "test-subcategory-221"

    }

    },

]

}

如何达到需要的结果。我真的被困在这里了。

Answer 1

这应该可以做到：$list = Category::select('id', 'name', 'slug')                ->where([                    'in_menu' => 1,                    'status' => 1,                    'deleted_at' => null                ])                ->orderBy('id', 'desc')                ->get();$data = [];foreach ($list as $category) {    $sublist = Subcategory::select('id', 'name', 'slug')                           ->where([                               'category_id' => $category->id,                               'status' => 1,                               'deleted_at' => null                           ])                           ->orderBy('id', 'desc')                           ->get();    $item = [        "id" => $category->id,        "name" => $category->name,        "slug" => $category->slug,        "subcategory" => [],    ];    foreach($sublist as $subcategory) {            $fsublist = Fsubcategory::select('id', 'name', 'slug')->where(array('subcategory_id' => $subcategory->id, 'status' => 1, 'deleted_at' => null))->orderBy('id', 'desc')->get();                        $subitems = [];            foreach($fsublist as $fsubcategory) {                $subitems[] = [                    "fsub_id" => $fsubcategory->id,                    "fsub_name" => $fsubcategory->name,                    "fsub_slug" => $fsubcategory->slug,                ];            }            $item["subcategory"][] = [                "sub_id" => $subcategory->id,                "sub_name" => $subcategory->name,                "sub_slug" => $subcategory->slug,                "fsubcategory" => $subitems,            ];        }    $data[] = $item;}return response()->json(['response' => 200, 'data' => $data]);