title: inner join two foreign key in one table
body: <p>i have query sql for searching. i have two table to be inner join. this my table : </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>table_order
  ------------
  id_order  id_user_order  id_user_taker  status
  1          2              3              done
  2          2              4              done
  
  table_user
  --------------
  id_user    name
  1          Alex
  2          Jason
  3          Danis
  4          Lorent</code></pre>
  </div>
  </div>
  </p>
  
  <p>i will inner join like this : </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
  include'conn.php'
  $qry = $conn-&gt;query("select table_order.*, table_user.name AS order_name, table_user.name AS taker_name FROM table_order INNER JOIN table_user ON table_user.id_user = table_order.id_user_order INNER JOIN table_user ON table_user.id_user = table_order.id_user_taker ");
  
  while($data = $qry-&gt;fetch_assoc()){
  echo $data['order_name'] . " " . $data['taker_name'];
  }
  
  ?&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>but, cannot show. Please solve my problem guys. thanks so much</p>