src/Repositories/Character/Pi.php
public function getCharacterPlanetaryColonies(int $character_id): Collection
    {

        return CharacterPlanet::where('character_id', $character_id)
            ->join('mapDenormalize as system', 'system.itemID', '=', 'solar_system_id')
            ->join('mapDenormalize as planet', 'planet.itemID', '=', 'planet_id')
            ->select('character_planets.*', 'system.itemName', 'planet.typeID')
            ->get();
    }
public function getCharacterPlanetaryColonies(int $character_id): Collection
    {

        return CharacterPlanet::where('character_id', $character_id)
            ->join('mapDenormalize as system', 'system.itemID', '=', 'solar_system_id')
            ->join('mapDenormalize as planet', 'planet.itemID', '=', 'planet_id')
            ->select('character_planets.*', 'system.itemName', 'planet.typeID')
            ->get();
    }
public function getCharacterPlanetaryColonies ( int $ character_id ) : Collection { return CharacterPlanet :: where ( 'character_id' , $ character_id ) -> join ( 'mapDenormalize as system' , 'system.itemID' , '=' , 'solar_system_id' ) -> join ( 'mapDenormalize as planet' , 'planet.itemID' , '=' , 'planet_id' ) -> select ( 'character_planets.*' , 'system.itemName' , 'planet.typeID' ) -> get ( ) ; }
Return the Planetary Colonies for a character.

@param int $character_id

@return \Illuminate\Support\Collection
Return the Planetary Colonies for a character .