关于数据构建一个数据表的问题，有没有快一点的方式构建出想要的数据表

图挂了，写代码块吧

$categoryList = array_unique(array_column($data, 'category'));
array_unshift($categoryList, '');
$a = [];
foreach ($data as $val) {
    $a[$val['category']][$val['rank']] = $val['score'];
}
$b = [$categoryList];
for ($i = 1; $i < 3; $i++) {
    $topRank = '#' . $i;
    $rowData = array($topRank);
    foreach ($a as $key => $val) {
         $rowData[] = $a[$key][$topRank];
    }
    $b[] = $rowData;
}
dd($b);

结果：

array:3 [▼
  0 => array:4 [▼
    0 => ""
    1 => "aaa"
    2 => "bbb"
    3 => "ccc"
  ]
  1 => array:4 [▼
    0 => "#1"
    1 => 50
    2 => 150
    3 => 98
  ]
  2 => array:4 [▼
    0 => "#2"
    1 => 222
    2 => 220
    3 => 33
  ]
]

@study_laraveler 我个人觉得你那个格式对于前端来说，太不规范了。当然，以能用就行来说，也挺好的。想必弄成这种格式肯定是要做表格吧，那肯定需要有对应的表头。你的那个数据格式，一旦category过多，对于前端来说，对比数据就太费劲了。我这里就抛个砖吧：

$data_collect = collect($data);

$result = $data_collect
  ->pluck('rank')
  ->unique()
  ->map(function ($rank) use ($data_collect) {

    $row = [
      'rank' => $rank,
    ];

    $data_collect
    ->where('rank', $rank)
    ->map(function ($cell) use (&$row) {
      $row[$cell['category']] = $cell['score'];
    });

    return $row;
  })
  ->toArray();

dd($result);

结果：

array:2 [▼
  0 => array:4 [▼
    "rank" => "#1"
    "aaa" => 50
    "bbb" => 150
    "ccc" => 98
  ]
  3 => array:4 [▼
    "rank" => "#2"
    "aaa" => 222
    "bbb" => 220
    "ccc" => 33
  ]
]