laravel join select column using where clause code example

Example: select selected fields in laravel join

->select('accounts.*', 'users.id as uid','users.user_name');