php替换数组键,php替换数组id键

我使用单个mysql查询为嵌套结果(类别和子类别)创建多维数组。

询问

SELECT `categories`.`cat_title`, `subcategories`.`sub_cat_id`, `subcategories`.`sub_cat_title`

FROM (`categories`)

LEFT JOIN `subcategories`

ON `subcategories`.`cat_id` = `categories`.`cat_id`

ORDER BY `categories`.`cat_title创建多维数组

$array = array();

foreach ($query->result_array() as $row): //query result as a pure array

$array[$row['cat_title']][] = $row['sub_cat_title'];

endforeach;

return $array;以上返回类别和它们各自的子类别。

Array (

[Art] => Array ( [0] => Graphic Design [1] => Painting )

[Literature] => Array ( [0] => Science Fiction [1] => Poetry [2] => Fiction )

[Science] => Array ( [0] => Environmental )

)是否可以使用查询数据替换数组键，如子类别ID sub_cat_id？例如

[Literature] => Array ( [8] => Science Fiction [94] => Poetry [5] => Fiction )