PHP & mysql 显示来自多个表的数据

Question

我有两个表，其中包含如下所述的数据:

Table1

TID     Name
 1      Salman 
 2      ABC 
 3      XYZ

表2

SID     STID   SUBJECT
 1       1      English
 2       1      Math
 3       2      Physics
 4       2      Math

Table2 STID 中的 Table1 TID 外键。我想从两个表中收集数据并在 PHP 中显示，如下所述:

Name        Subject1    Subject2
Salman      English     Math
ABC         Physic      Math

Answer 1

有我的建议算法

$mysqli = new mysqli("HOST", "USER NAME", "USER PASS", "YOUR DATABASE");
$result = $mysqli->query("SELECT * FROM table1");
while ($row = $result->fetch_assoc()){
$TID = $row['TID'];
$Name = $row['Name'];
$result2 = $mysqli->query("SELECT * FROM table2 where `TTID` = $TID");
echo "$Name \t";
while ($row2 = $result2->fetch_assoc()){
$SUBJECT = $row2['SUBJECT'];
echo "$SUBJECT \t";
}
echo '<br/>';
}
$mysqli->close();