如何将此数组存储在foreach循环中

Question

我需要以这种格式存储一个数组

array(2)
{
[1002] => array(2)
{
[0] => string(1) "2"
[1] => string(1) "1"
}
}

到目前为止，我只有这个：

function permissions($conn){
$sql="SELECT PROCESS,PERMISSION FROM table WHERE PROCESS=1002";
$result = $conn->executeSQL($sql);
$return = array(); 
foreach($result as $value){
array_push($return,$value['PROCESS_ID'],$value['PERMISSION_ID']);     
}

这带来：我不知道如何使这个数组成为多维的，我不想要"；1002"；重复

array(2)
{
[0] => string(4) "1002"
[1] => string(1) "2"
[2] => string(4) "1002"
[3] => string(1) "1"
}

Answer 1

嗨，试试这样的东西：

function permissions($conn){
$sql="SELECT PROCESS,PERMISSION FROM table WHERE PROCESS=1002";
$result = $conn->executeSQL($sql);
$return = array(); 
foreach($result as $value){
if(!isset($return[$value['PROCESS_ID']])){
$return[$value['PROCESS_ID']] = [];
}

$return[$value['PROCESS_ID']][] = $value['PERMISSION_ID'];     
}