如果我理解正确的话，你的解决方案可能类似沿着这些路线。

<?php
// Get the current month
$currentMonth = date('m');

// SQL query with prepared statement
$query = "
SELECT CONCAT(spouse1.fname, ' & ', spouse2.fname) AS couple_names, doa
FROM table_two
JOIN table_one AS spouse1 ON table_two.spouse1_ID = spouse1.ID
JOIN table_one AS spouse2 ON table_two.spouse2_ID = spouse2.ID
WHERE MONTH(doa) = ?
";

// Assuming you have already established a database connection
$stmt = mysqli_prepare($connection, $query);
mysqli_stmt_bind_param($stmt, 's', $currentMonth);
mysqli_stmt_execute($stmt);

// Get the result set
$result = mysqli_stmt_get_result($stmt);

// Check if any results were returned
if (mysqli_num_rows($result) > 0) {
  // Loop through the rows and display the couples
  while ($row = mysqli_fetch_assoc($result)) {
    $coupleNames = $row['couple_names'];
    $anniversaryDate = date('d F Y', strtotime($row['doa']));
    
    echo "$coupleNames - $anniversaryDate<br>";
  }
} else {
  echo "No couples found celebrating this month.";
}

// Close the prepared statement and the database connection
mysqli_stmt_close($stmt);
mysqli_close($connection);
?>

字符串