Laravel 5 Eloquent scope join and select specific columns You may try this: ->select('accounts.*', 'users.id as uid','users.user_name');