CODE EXAMPLE FOR PHP

laravel where on relationsship column

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