laravel eleoquent gettig related fieds as code example
Example 1: laravel where on relationsship column
Player::whereHas('roleplay', function($q){
$q->where('column_name', 'value');
})->get();
Example 2: Laravel DB facade relations
$antiques = DB::table('antiques')
->join('images', 'images.antiques_id', '=', 'antiques.id')
->latest()
->limit(20)
->get(['antiques.*', 'images.path']);