在posts表中插入cat_id和cat_name

我想将类别id和标题插入posts表。请检查下面的图片。

• category table

• posts table where i want to insert my category id and table

现在我的代码是

<?php
  include 'db.php';
?>
<form action="<?Php $_SERVER['PHP_SELF']; ?>" method="POST">
  <input type="text" name="title" required="">
  <input type="text" name="content" required="">
  <select name="category">
    <?php
      $query = mysqli_query($conn, "SELECT * FROM `category`");
      while ($row = mysqli_fetch_assoc($query)) {
    ?>
    <option value="<?php echo $row['id']; ?>"><?php echo $row['title']; ?></option>
    <?php
    }
    ?>
  </select>
  <button type="submit" name="add">Add Blog</button>
</form>
<?php
  if (isset($_POST['add'])) {
    @$title = $_POST['title'];
    @$category = $_POST['category'];
    @$content = $_POST['content'];
    @$date = date("D M Y");

    mysqli_query($conn, "INSERT INTO `posts` (`id`, `image`, `title`, `date`, `cat_id`, `cat_name`, `short_description`, `content`) VALUES  (NULL, 'NO_IMAGE', '".$title."', '".$date."', '".$cat_id."', '', '', '".$content."')");
    echo "success!";
  }
?>

现在,我如何添加插入类ID,标题到帖子Casiid,CasnNead使用select选项或其他选项是可用的。

谢谢