How to alias a left joined table in laravel eloquent

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

Laravel Selecting and Aliasing Columns in Eloquent’s query