Laravel Eloquent Nested Group by its Relation

Please help me how to add another nested group by based on game category relation. I have 3 tables related using laravel 5.4 eloquent.

Game Providers Table

+----+-------------+--------------+------------------+
| id | game_name   | game_type_id | game_category_id |
+----+-------------+--------------+------------------+
|  1 | Sample      |      1       |         1        |
|  1 | Sample 0    |      1       |         2        |
|  2 | Sample 1    |      2       |         1        |
|  3 | Sample 2    |      2       |         2        |
+----+-------------+--------------+------------------+

Game Types

+----+-------------+
| id | name        |
+----+-------------+
|  1 | Chess       |
|  2 | Poker       |
+----+-------------+

Game Categories

+----+-------------+
| id | name        |
+----+-------------+
|  1 | Recommended |
|  2 | Optional    |
+----+-------------+

I'm done of for first nested for game type relation but i dont know how to add another group by for game categories

$game_providers = GameProvider::all();

$game_providers = $game_providers->groupBy(function ($game_provider) {
    return $game_provider->game_type->name;
})->all();

and its output

Array{
 'Chess' => Array{
    0 => Array{
     'id'               => 1,
     'game_name'        => 'Sample',
     'game_type_id'     => 1,
     'game_category_id' => 2
    },
    1 => Array{
     'id'               => 2,
     'game_name'        => 'Sample 0',
     'game_type_id'     => 1,
     'game_category_id' => 2
    },
  },
 'Poker' => Array{
    0 => Array{
     'id'               => 3,
     'game_name'        => 'Sample 1',
     'game_type_id'     => 2,
     'game_category_id' => 1
    },
    1 => Array{
     'id'               => 4,
     'game_name'        => 'Sample 2',
     'game_type_id'     => 2,
     'game_category_id' => 2
    },
  },

}

My expected output.

Array{
 'Chess' => Array{
    'Recommended' => Array{
        0 => Array{
           'id'               => 1,
            'game_name'        => 'Sample',
            'game_type_id'     => 1,
            'game_category_id' => 2
        }
    },
    'Optional' => Array{
        0 => Array{
            'id'               => 2,
            'game_name'        => 'Sample 0',
            'game_type_id'     => 1,
            'game_category_id' => 2
        }
    }
  },
 'Poker' => Array{
    'Recommended' => Array{
        0 => Array{
            'id'               => 3,
            'game_name'        => 'Sample 1',
            'game_type_id'     => 2,
            'game_category_id' => 1
        }
    },
    'Optional' => Array{
        0 => Array{
            'id'               => 4,
            'game_name'        => 'Sample 2',
            'game_type_id'     => 2,
            'game_category_id' => 2
        }
    }     
  }

}

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2wlVrWY
via IFTTT