title: Laravel cannot get duplicate value datas using join query
body: <p>I using laravel 5.3 in my project.</p>
  
  <p>I want to get result for duplicate value (i.e.,)If the column has same id it should be displayed.</p>
  
  <pre><code>public function getSendedRequests($broker_id) {
      $broker = User::where('broker_id', $broker_id)-&gt;lists('id');
      //my customer sended request
      $getUser = ProfileRequest::whereIn('requested_id', $broker)-&gt;lists('requested_id');
      $getReq = ProfileRequest::whereIn('requested_id', $broker)-&gt;lists('user_id');
      $sendUsers = $this-&gt;commonRequestQuery($getUser);
      $receivedUsers = $this-&gt;commonRequestQuery($getReq);
      return view('profilerequest')-&gt;with(['sendUsers' =&gt; $sendUsers-&gt;paginate(10), 'receivedUsers' =&gt; $receivedUsers-&gt;get(), 'title' =&gt; trans('messages.customer-sended-requests')]);
  }
  
  public function commonRequestQuery($values) {
      return DB::table('users')
          -&gt;leftJoin('basic_informations', 'users.id', '=', 'basic_informations.user_id')
          -&gt;leftJoin('physical_attributes', 'users.id', '=', 'physical_attributes.user_id')
          -&gt;leftJoin('religion_and_ethnicity', 'users.id', '=', 'religion_and_ethnicity.user_id')
          -&gt;leftJoin('occupational_attributes', 'users.id', '=', 'occupational_attributes.user_id')
          -&gt;leftJoin('personal_interests', 'users.id', '=', 'personal_interests.user_id')
          -&gt;select('users.id', 'users.user_name', 'users.email', 'users.gender', 'basic_informations.age', 'basic_informations.unique_id', 'basic_informations.mother_tongue', 'religion_and_ethnicity.religion_id', 'religion_and_ethnicity.caste_id', 'occupational_attributes.education_id', 'occupational_attributes.occupation_id')
          -&gt;whereNotNull('basic_informations.user_id')
          -&gt;whereNotNull('physical_attributes.user_id')
          -&gt;whereNotNull('religion_and_ethnicity.user_id')
          -&gt;whereNotNull('occupational_attributes.user_id')
          -&gt;whereIn('users.id', $values);
  }
  </code></pre>
  
  <p>I get users id from user table for same broker and check whether they have requested some one in another table.</p>
  
  <p>My problem is if the same user requested for two another users then i cannnot get result twice instead of that i can get only one time but another users(request received users is displayed propery).</p>
  
  <p>Profile request table looks like image
  <a href="https://i.stack.imgur.com/GoQyl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GoQyl.png" alt="enter image description here"></a></p>
  
  <p>In requested_id table im having same id two times i want to display parallely like <strong>Who requested for whom</strong></p>