PHP 从嵌套查询中选择字段

我正在对 2 个表运行查询，以从博客返回信息。嵌套查询选择与该博客关联的标记，该博客是一个单独的表。

我希望能够从"标签"表中获取"标签"行并在页面上显示这些行。我的代码在下面，我已经评论了我希望选择行的位置。

<?php
include("inc/dbconnection.php");
$id     = $_GET['tag'];
$id     = trim($id);
$result = mysqli_query($conn, "
SELECT * 
  FROM blog 
 WHERE blog_id IN (SELECT blog_id FROM tags WHERE tag = '$id')
");
if (!$result) {
    die("Database query failed: " . mysqli_error($conn));
} //!$result
else {
    $rows = mysqli_num_rows($result);
    if ($rows > 0) {
        while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
            $content  = $row['content'];
            $content2 = substr($content, 0, 100);
            /* Below is where I would like to pull the row 'tag' from the nested query */
            $rawTag   = $row['tag'];
            $tag      = str_replace(" ", "", $rawTag);
            $tagArray = explode(",", $tag);
            $tag      = "";
            for ($i = 0; $i < count($tagArray); $i++) {
                $tag .= "<a href='tag-" . $tagArray[$i] . ".php'>" . $tagArray[$i] . "</a> ";
            } //$i = 0; $i < count($tagArray); $i++
            echo "
                  <table>
                    <tr>
                      <th>
                        <a href='blog-" . $row['blog_id'] . ".php'>
                          <h2>" . $row['title'] . "</h2>
                        </a>
                      </th>
                    </tr>
                    <tr>
                      <td>
                        <p>" . date("d/m/Y", strtotime($row['createdDate'])) . "</p><br />
                        <span>" . $content2 . "...</span><br />
                        <span><small>Tags: " . $tag . "</small></span>
                      </td>
                    </tr>
                  </table>";
        } //$row = mysqli_fetch_array($result, MYSQLi_ASSOC)
    } //$rows > 0
    else { //$rows > 0
        echo "<br /><h1>There are currently no blogs with the selected tag (" . $_GET['tag'] . ")</h1><br /><h2>Please check back later.</h2>";
    }
}
?>

抱歉，如果这是一个愚蠢的问题，请提前感谢您的帮助:)