public static function board_generate($game_id) { $game_board_letters = \App\Models\Game_User::join('game_board_user', 'game_user.id', '=', 'game_board_user.game_user_id')->where('game_user.game_id', '=', $game_id)->select('game_board_user.x', 'game_board_user.y', 'game_board_user.letter_id'); $board = []; $cont = 1; for ($i = 1; $i < 16; $i++) { for ($j = 1; $j < 16; $j++) { $type = self::types($cont); $board[$i][$j] = ['letter' => null, 'type' => $type->type, 'multiplier' => $type->multiplier]; $cont++; } } $game_users = \App\Models\Game_User::where('game_id', '=', $game_id)->get(); $game_board = collect(); foreach ($game_users as $game_user) { $game_board->push(\App\Models\Game_Board_User::where('game_user_id', '=', $game_user->id)->get()); } foreach ($game_board as $letters) { foreach ($letters as $cell) { $complete_letter = \App\Models\Letter::find($cell->letter_id); $board[$cell->x][$cell->y]['letter'] = $complete_letter; } } return $board; }