How to concatenate 2 arrays in php?

Question

Laravel

The bottom line is this:
There are 2 arrays, the first one is simply numbered:

$clear = [];
      for ($i = 1; $i <= 10; $i++) {
        $clear[] = [
                                'mesto' => $i,
                            ];
      }

It looks like this:

spoiler

The second from the database with values

$mesta2 = \DB::table('mesta')->where('game_id', 595)->get();

Looks like that:

spoiler

The target is to append to an empty array i.e. first, information from the second by 'mesto'
To get something like this:

spoiler

Tried array_merge($clear,$mesta2); Just adds to the end
Tried $clear+$mesta2 just nothing happens
If you can write the code right away)

Answer 1

Did so

$mesta2 = \DB::table('mesta')
      ->where('game_id', $gameId)
      ->join('users', 'mesta.user_id64', '=', 'users.id64')
          ->select(['mesta.*','users.username as username','users.avatar as avatar'])
      ->get();  

      $clear = [];
for ($i = 1; $i <= $game->mest_all; $i++) {
      $find = 0;		     
             foreach($mesta2 as $mestos) {
                if($find == 0) {
                    if($mestos->mesto == $i) {
                        $find++;
            $i++;
            $clear[] = $mestos;
          }
        }			
      }
  $clear[] = [
                'mesto' => $i,
               ];
}
$mesta = json_encode($clear);

Answer 2

It fails because $mesta2 is a collection, not an array.

$clear = ...;
$mesta2 = ...;
$result = array_merge($clear, $mesta2->toArray())

Answer 3

$clear = [];
for ($i = 1; $i <= 10; $i++) {
    $clear[] = [
        'mesto' => $i,
    ];
}

$mesta2 = \DB::table('mesta')->where('game_id', 595)->get()->keyBy('mesto');
$result = \Illuminate\Support\Collection::make($clear)->map(function ($item) use ($mesta2) {
    if ($persistedItem = $mesta2->get($item['mesto'])) {
        return $persistedItem;
    }
    return $item;
});