Как сгрупировать одно поле многомерного массива?

Question

[AlpineMilk]

Есть массив вида:

array:4 [▼
  0 => array:7 [▼
    "answer_schema_id" => "1"
    "content" => "odpowiedz 1"
    "locale" => "pl"
    "points" => "3"
    "answerKey" => "1"
    "answerElementOrder" => "1"
    "image" => "5cd143beba821203428009.jpg"
  ]
  1 => array:7 [▼
    "answer_schema_id" => "1"
    "content" => "answer 1"
    "locale" => "en"
    "points" => "3"
    "answerKey" => "1"
    "answerElementOrder" => "1"
    "image" => "5cd143beba821203428009.jpg"
  ]
  2 => array:7 [▼
    "answer_schema_id" => "2"
    "content" => "answer 2"
    "locale" => "en"
    "points" => "2"
    "answerKey" => "2"
    "answerElementOrder" => "2"
    "image" => "5cd143bebcdfc405126844.jpg"
  ]
  3 => array:7 [▼
    "answer_schema_id" => "2"
    "content" => "odpowiedz 2"
    "locale" => "pl"
    "points" => "2"
    "answerKey" => "2"
    "answerElementOrder" => "2"
    "image" => "5cd143bebcdfc405126844.jpg"
  ]
]

Нужно получить следующий массив:

array:4 [▼
  0 => array:7 [▼
    "answer_schema_id" => "1"
    "content" => [
        "pl" => 'odpowiedz 1',
        "en" => 'answer 1'    
     ]
    "points" => "3"
    "answerKey" => "1"
    "answerElementOrder" => "1"
    "image" => "5cd143beba821203428009.jpg"
  ],
1 => array:7 [▼
    "answer_schema_id" => "2"
     "content" => [
        "pl" => 'odpowiedz 2',
        "en" => 'answer 2'    
     ]
    "points" => "2"
    "answerKey" => "2"
    "answerElementOrder" => "2"
    "image" => "5cd143bebcdfc405126844.jpg"
  ]
]

Но у меня получается откровенно какая-то дич.
Вот мой код:

$new = [];

foreach ($data as $key => $datum){
            if(empty($new)){
                $new[] = $datum;
                unset($new[0]['content']);
            }

            foreach ($new as $keyz => $item){
                if($item['answer_schema_id'] == $datum['answer_schema_id']){
                    $new[$keyz]['content'][$datum['locale']] = $datum['content'];
                }
            }
        }

Прошу помощи в решении данной проблемы

Answer 1

[Rsa97]

$arr = [
  [
    "answer_schema_id" => "1",
    "content" => "odpowiedz 1",
    "locale" => "pl",
    "points" => "3",
    "answerKey" => "1",
    "answerElementOrder" => "1",
    "image" => "5cd143beba821203428009.jpg",
  ], [
    "answer_schema_id" => "1",
    "content" => "answer 1",
    "locale" => "en",
    "points" => "3",
    "answerKey" => "1",
    "answerElementOrder" => "1",
    "image" => "5cd143beba821203428009.jpg",
  ], [
    "answer_schema_id" => "2",
    "content" => "answer 2",
    "locale" => "en",
    "points" => "2",
    "answerKey" => "2",
    "answerElementOrder" => "2",
    "image" => "5cd143bebcdfc405126844.jpg",
  ], [
    "answer_schema_id" => "2",
    "content" => "odpowiedz 2",
    "locale" => "pl",
    "points" => "2",
    "answerKey" => "2",
    "answerElementOrder" => "2",
    "image" => "5cd143bebcdfc405126844.jpg",
  ]
];
$result = [];
$ptr = [];
foreach ($arr as $el) {
  if (!isset($ptr[$el['answer_schema_id']])) {
    $res[] = [
      "answer_schema_id" => $el['answer_schema_id'],
      "content" => [],
      "points" => $el['points'],
      "answerKey" => $el['answerKey'],
      "answerElementOrder" => $el['answerElementOrder'],
      "image" => $el['image']
    ];
    $ptr[$el['answer_schema_id']] = count($res)-1;
  }
  $res[$ptr[$el['answer_schema_id']]]['content'][$el['locale']] = $el['content'];
}
var_dump($res);

array(2) {
  [0] => array(6) {
    ["answer_schema_id"] => string(1) "1"
    ["content"] => array(2) {
      ["pl"] => string(11) "odpowiedz 1"
      ["en"] =>string(8) "answer 1"
    }
    ["points"] => string(1) "3"
    ["answerKey"] => string(1) "1"
    ["answerElementOrder"] => string(1) "1"
    ["image"] => string(26) "5cd143beba821203428009.jpg"
  }
  [1] => array(6) {
    ["answer_schema_id"] => string(1) "2"
    ["content"] => array(2) {
      ["en"] => string(8) "answer 2"
      ["pl"] => string(11) "odpowiedz 2"
    }
    ["points"] => string(1) "2"
    ["answerKey"] => string(1) "2"
    ["answerElementOrder"] => string(1) "2"
    ["image"] => string(26) "5cd143bebcdfc405126844.jpg"
  }
}

Comments

[AlpineMilk]

спасибо большое! Вы мне очень помогли! А чисто ради любопытства что обозначает сокращение переменной $ptr?

[Rsa97]

AlpineMilk, Pointer

[Сергей Попов]

Rsa97, не с плюсов начинал, случаем? Этого понятия в PHP в чистом виде не существует.

[Rsa97]

Сергей Попов, Нет, когда я начинал, плюсы ещё в зародыше были. МК-61, Basic, ASM (КР580ВМ80А, PDP11, 6502, x86), Fortran, Pascal, C.

[Сергей Попов]

Rsa97, тогда не удивительно. В целом, такой подход очень хорош, но на мой взгляд, здесь, в целом, можно поискать более элегантные способы. Уж очень сложный для чтения код получился.

[Rsa97]

Сергей Попов, Можно. Например, можно сначала сделать ассоциативный массив, потом его просто перевести в обычный через array_values.
А если данные запрашиваются из базы, то можно сразу запросом получить нужную структуру, сформировав content через CONCAT и GROUP_CONCAT в JSON-формате.