Retrieve Data From Pivot Table

[osherdo]

I have this pivot table:

http://3.1m.yt/0_7a5sa.png

I need to return multiple names of users (from users table) that have at least one expectation_id value as the current user have.

How do I achieve that? Do I need to iterate with foreach loop and use Auth::user() to do this?

Thanks.

[osherdo]

public function mutual()
    { 
      $mutualUsers = DB::table('expectation_profile')->where(expectation_id,);

    }

I am trying to write the query now. Not done with it yet.

[Psycho]

I had to make some assumptions on the field names in the users table:

 

SELECT DISTINCT users.username
FROM users
JOIN expectation_profile
    ON users.profile_id = expectation_profile.profile_id
 
WHERE users.profile_id <> $currentUserID
  AND expectation_profile.expectation_id IN (
      SELECT expectation_id
      FROM expectation_profile
      WHERE profile_id = $currentUserID
)

[osherdo]

@Psycho are you familiar with laravel by accident?

[Psycho]

@Psycho are you familiar with laravel by accident?

 

I have no clue about Laravel. What I posted was just an SQL query.