How can I use a foreach or for loop to transfer data from one array to another for subsequent output in XML?

Question

PHP

There is an XML generator (a third-party module connected to a Yii2 application). Now one last entry is output in XML, but it is necessary that all of them are output ... How to do it, help, I have already broken my head)

//Выборка из БД
$results = Markers::findBySql("SELECT markers.*, categories.category FROM categories LEFT JOIN markers ON markers.category_id = categories.id WHERE markers.category_id = categories.id")
            ->asArray()
            ->all();

        $xml = new XmlConstructor();
        $res=array();$k=0;
        foreach ($results AS $elements) {

            $elements=[
                'tag' => 'marker',
                'attributes' => [
                    'id' => $elements[id],
                    'name' => $elements[title],
                    'address' => 'Конюшенная',
                    'lat' => $elements[lat],
                    'lng' => $elements[lng],
                    'type' => $elements[category]
                ],
            ];

        }

        $result = [
            [
                'tag' => 'markers',
                'elements' => [
                    $elements
                ],
            ],
        ];
        return $xml->fromArray($result)->toOutput();

Answer 1

I think something like this

foreach ($results as $elements) {
    $res[] = [
        'tag' => 'marker',
        'attributes' => [
            'id' => $elements['id'],
            'name' => $elements['title'],
            'address' => 'Конюшенная',
            'lat' => $elements['lat'],
            'lng' => $elements['lng'],
            'type' => $elements['category']
        ],
    ];
}

should help.

Answer 2

$result = array_map(function($el) {
  return [
    'tag' => 'marker',
    'attributes' => [
      'id' => $el['id'],
      'name' => $el['title'],
      'address' => 'Конюшенная',
      'lat' => $el['lat'],
      'lng' => $el['lng'],
      'type' => $el['category']
    ]
  ];
}, $result);