在创建MySQL查询以更新用户的多个选择或其他建议方面需要帮助
我有一个页面，用户可以选择3至6个兴趣点，通过点击动态生成的按钮。我已经能够成功地将所选兴趣插入到数据库中，但我正在尝试为用户可能希望更新其先前选择的场景做准备。对于如何编写SQL查询或如何让用户更新他们以前选择的兴趣，有什么建议吗？从“利息”表中查询利息，表中的列为：id - name - description - navigation - seo_name和所选兴趣将插入member_interests表，表中的列为：interest_id - member_id。我能够通过删除以前选择的兴趣并创建新的兴趣来解决它。但我觉得这条路不太好走。

public function getAll(): array
{
    $sql = "SELECT id, name, description, navigation, seo_name 
      FROM interest;";                                 // SQL to get all interest
    return $this->db->runSQL($sql)->fetchAll();      // Return all interest
}

public function create(int $interestId, int $memberId): bool
{
     $sql    = "INSERT INTO member_interests (interest_id, member_id) 
                VALUES (:interest_id, :member_id);";            // SQL
     $params = array('interest_id' => $interestId, 'member_id' => $memberId);
    $this->db->runSQL($sql, $params);                        // Run SQL
    return true;                                           // Return true
}

public function deleteByMember(int $memberId): void
    {
        $sql = "DELETE FROM member_interests WHERE member_id = :member_id";
        $params = [
            'member_id' => $memberId
        ];
        $this->db->runSQL($sql, $params);
    }

..{
    $checkedCount = count($interestsChosen);
    if ($checkedCount < 3 || $checkedCount > 6) {
      $errors['message'] = 'Please select 3-6 interests.';                  // If the number of selected interests is less than 3 or more than 6, set the error message to 'Please select 3-6 interests.'
    } else {
      // Check if the user has previously chosen interests
      $previousInterests = $cms->getInterest()->getInterestName($cms->getSession()->id);
      $previousInterestIds = array_column($previousInterests, 'interest_id');

      if (count($previousInterestIds) > 6) {
        $errors['message'] = 'You can only choose up to 6 interests.'; // Set error message if user has already chosen interests and the total exceeds 6
      } else {
        // Delete existing interests for the user
        $cms->getInterest()->deleteByMember($cms->getSession()->id);

        // Iterate over the chosen interests and create them
        foreach ($interestsChosen as $interestId) {
          $cms->getInterest()->create(intval($interestId), $cms->getSession()->id);
        }

        if ($previousInterestIds) {
          // User had previously chosen interests, redirect to interests updated page
          redirect('interest-updated/', ['success' => 'Interests updated!']);
        } else {
          // User didn't have previously chosen interests, redirect to the next step in the onboarding process
          redirect('onboard-occupation/');
        }
      }
    }
  }