Laravel关系2层

Question

I have my database (=model) structure like that:

game:  
    lot (typeof Lot)
    places (array type of Place)
         place_id // just a number of a lot in some game
         user_id

What should I do to call in everywhere like this:

User::find(1)->games() // returns Game collection where user has places

?

Models are:

class Place extends Model
{
    protected $fillable = ['place_id', 'user_id', 'game_id'];

    public function user() {
        return $this->belongsTo(User::class);
    }

    public function game() {
        return $this->belongsTo(Game::class);
    }
}

User:

class User extends Model implements AuthenticatableContract,
                                    AuthorizableContract,
                                    CanResetPasswordContract
{
    use Authenticatable, Authorizable, CanResetPassword;

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'users';

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = ['name', 'email', 'steam_id', 'avatar'];

    /**
     * The attributes excluded from the model's JSON form.
     *
     * @var array
     */
    protected $hidden = ['remember_token'];

    /**
     * Get all of the tasks for the user.
     */
    public function items()
    {
        return $this->hasMany(SteamItem::class);
    }

    public function places() {
        return $this->hasMany(Place::class);
    }
}

The Game:

class Game extends Model
{
    protected $fillable = ['lot_id'];

    public function lot() {
        return $this->belongsTo(Lot::class);
    }

    public function places() {
        return $this->hasMany(Place::class);
    }
}

Now I use this code in my User class:

public function games() {
    return Game::with(['places' => function ($query) {
        $query->where('user_id', $this->id);
    }]);;
}

It doesn't work, because I need to make it as a relationship method, but with method returns a query builder.

In the finals I must call $user->games and it should return me all the games user linked to through place.

Answer 1

Okay. I think I understand now.

User has many Place. Place belongs to User. Place belongs to Game. Game has many Place.

You can try this:

$user = User::with('places.game.lot')->find(1);

This will fetch the User and eager load all the relationships. Because Place belongsTo a Game, which in turn belongs to Lot, you can then do this:

@foreach ($user->places as $place)
    <img src="{{$place->game->lot->imageUrl}}" />
@endforeach

Also, place is actually a pivot table, and you can take advantage of Eloquent's many-to-many relationship, which I would recommend reading about.