$product_data = $pdo->query(
        "SELECT
          p.url AS url,
          p.description AS description,
          p.info AS info,
          p.note AS note,
          p.content AS content,
          p.name AS pname,
          p.icon AS icon,
          p.price AS price,
          p.original_price AS original_price,
          p.prod_id AS prod_id,
          p.stock AS stock,
          p.views AS views,
          s.name AS sname,
          c.name AS cname
        FROM `product` as p
        JOIN
          `store` as s ON p.store_id = s.store_id
        JOIN
          `category` as c ON c.category_id = p.category_id
        WHERE
          p.active = '1'
        ORDER BY `prod_id` DESC "
      );

while($row = mysqli_fetch_array($product_data)){
      $theme = $pdo->query(
        "SELECT
        t.name as tname
        FROM `product` as p
        JOIN
          `product_theme` as pt ON p.prod_id = pt.prod_id
        JOIN
          `theme` as t ON t.theme_id = pt.theme_id
        WHERE
          p.prod_id = '{$row['prod_id']}' "
      );

如圖，這是我在 while 迴圈又查詢一次的樣子
想問一下如果是這個程式碼
我能怎麼把它改成，只要在 $product_data 就能一次做完所有事？
這是有可能做到的嗎？