原始數據中 ~~~ “table_name”：字段所屬表 “field_name“ ： 字段名 “field_col_num"：字段排序號 ~~~ 期待輸出的結果是 ~~~ { "table_name" : [ "field_name", "field_name", .... ] } ~~~ 原始數據： ``` [ { "table_name": "dp", "field_name": "dpcryptfeat", "field_col_num": "6" }, { "table_name": "dp", "field_name": "dppath", "field_col_num": "4" }, { "table_name": "dp", "field_name": "dpauthfeat", "field_col_num": "5" }, { "table_name": "dp", "field_name": "dpnick", "field_col_num": "3" }, { "table_name": "icc", "field_name": "iccbufsizeprot", "field_col_num": "13" }, { "table_name": "icc", "field_name": "iccmech", "field_col_num": "5" }, { "table_name": "icc", "field_name": "iccnick", "field_col_num": "3" }, { "table_name": "icc", "field_name": "iccprocmanager", "field_col_num": "8" }, { "table_name": "icc", "field_name": "iccdesc", "field_col_num": "4" }, { "table_name": "icc", "field_name": "iccprot", "field_col_num": "6" }, { "table_name": "icc", "field_name": "iccformatprot", "field_col_num": "14" } ] ``` 輸出結果： ~~~ { "dp": [ "dpnick", "dppath", "dpauthfeat", "dpcryptfeat" ], "icc": [ "iccnick", "iccdesc", "iccmech", "iccprot", "iccprocmanager", "iccbufsizeprot", "iccformatprot" ] } ~~~ # 解決一 ~~~ dd(collect(json_decode($input))->groupBy('table_name')->map(function($item){ return collect($item)->sortBy('field_col_num')->map(function($data) { return $data->field_name; })->values(); })->toJson()); ~~~ # 解決二 ~~~ collect($groups)->sortBy('field_col_num')->groupBy('table_name')->map(function ($group) { return $group->pluck('field_name'); }); ~~~