title: Join query return duplicate data in laravel
body: <p>I have run a join query based on client_id between directsales and clients table.
  but when i print the query result it's show duplicated data.</p>
  
  <p>here, is my code.</p>
  
  <pre><code>public function readirectsalereport(Request $request)
  {
      $client_id=$request-&gt;client_id;
      $fromdate=$request-&gt;frmdate;
      $todate=$request-&gt;todate;
  
          $dsale=DB::table('directsales')
              -&gt;join('clients','directsales.client_id','=','clients.id')
              -&gt;select('clients.client_name','clients.addr')
              -&gt;where('directsales.client_id','=',$client_id)
              -&gt;get();
  
              return $dsale;
  
  }
  </code></pre>
  
  <p>and it's show this result.</p>
  
  <pre><code>[{"client_name":"majed10","addr":"Uttara"},{"client_name":"majed10","addr":"Uttara"}]
  </code></pre>