how to query inside laravel relations forming code example

Example 1: laravel where on relationsship column

Player::whereHas('roleplay', function($q){
   $q->where('column_name', 'value');
})->get();

Example 2: laravel eloquent relationships

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Project extends Model
{
    /**
     * Get all of the deployments for the project.
     */
    public function deployments()
    {
        return $this->hasManyThrough(Deployment::class, Environment::class);
    }
}