title: More than one Foreign Key from the same table
body: <p>I have a problem with this MySQL Statment. So basicly i have a table called games and i want to 
  display this table on my website. Table games has Foregin Keys like developer_id,
  publisher_id, categorie_id, platform1_id, platform2_id, platform3_id, platform4_id, platform5_id.
  I have 5 of platform because in Table platforms i have 5 records (PC, PS4, XB1, SWITCH, MOBILE). (If you guys know any better and easier solution to these platforms pls tell me.)
  So now my output on my website works but for example instead of showing developer name it shows
  it's ID. I know i have to INNER JOIN them and i probbably can INNER JOIN all foregin keys but the
  platform one. Because i dont know how to INNER JOIN if you have more then one FK from one table.</p>
  
  <p>If you need more info tell me. I will also include picture of my DB and my PHP code where i SELECT from table games.</p>
  
  <pre><code>$query = "SELECT * FROM games WHERE id = $id";
  $result = mysqli_query($link, $query) or die(mysqli_error($link));
  
  while ($row = mysqli_fetch_array($result)) {
      echo '&lt;tr&gt;';
      echo '&lt;td&gt;'.$row['developer_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['publisher_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['categorie_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['platform1_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['platform2_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['platform3_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['platform4_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['platform5_id'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['game_name'].'&lt;/td&gt;';
      echo '&lt;td&gt;'.$row['relese_date'].'&lt;/td&gt;';
      $intro = $row['introduction'];
      $desc = $row['description'];
      echo '&lt;td&gt;'.$row['rating'].'&lt;/td&gt;';
      echo '&lt;/tr&gt;'; 
  }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/VmFgb.png" rel="nofollow noreferrer">Picture of my DataBase</a></p>