Eloquent nested relations with where clause

Laravel Redirect To Another URL / Web Page - HTTP Laravel Redirects

Laravel Nested Relationships in Eloquent Example