Eloquent query - combine "with" and "join"

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

Laravel Eloquent Queries Joins Example