💎一站式轻松地调用各大LLM模型接口,支持GPT4、智谱、星火、月之暗面及文生图 广告
[TOC] 如何优化这种数据结构,用于存入到数据库中 原始数据结构 ~~~ [ [ "group"=>"A", "list"=>[ ["name"=>"1"], ["name"=>"2"], ["name"=>"3"], ] ], [ "group"=>"B" "list"=>[ ["name"=>"4"], ["name"=>"5"], ["name"=>"6"], ] ] ] ~~~ 转化后的数据结构 ~~~ [ ["group"=>"A","name"=>"1"], ["group"=>"A","name"=>"2"], ["group"=>"A","name"=>"3"], ["group"=>"B","name"=>"4"], ["group"=>"B","name"=>"5"], ["group"=>"B","name"=>"6"], ] ~~~ # 解决一 ~~~ $data = [ [ "group" => "A", "list" => [ ["name" => "1"], ["name" => "2"], ["name" => "3"], ] ], [ "group" => "B", "list" => [ ["name" => "4"], ["name" => "5"], ["name" => "6"], ] ] ]; dd(collect($data)->flatMap(function ($data) { return collect($data['list'])->map(function ($item) use ($data) { return ['group' => $data['group'], 'name' => $item['name']]; }); })->toArray()); ~~~ # 解决二 ~~~ $demo = [ ["group"=>"A", "list"=>[ ["name"=>"1"], ["name"=>"2"], ["name"=>"3"],] ], ["group"=>"B", "list"=>[ ["name"=>"4"], ["name"=>"5"], ["name"=>"6"],] ] ]; $middle = ''; dd( collect($demo)->flatten()->map( function($val) use(&$middle){ if(is_numeric($val)) { return ['name'=>$val,'group'=>$middle]; }else{ $middle = $val; } })->reject( function($val){ return !is_array($val); } ) ); ~~~