PHP/MySQL:在PHP多查询中将值从一个查询传递到另一个查询

$query1 = "SELECT column_name FROM table_name WHERE condition";
$result1 = mysqli_query($connection, $query1);
$row = mysqli_fetch_assoc($result1);
$value = $row['column_name'];

$query2 = "SELECT * FROM another_table WHERE another_column = '$value'";
$result2 = mysqli_query($connection, $query2);
// 继续处理$result2的结果

// 在第一个查询中将值存储到SESSION中
$query1 = "SELECT column_name FROM table_name WHERE condition";
$result1 = mysqli_query($connection, $query1);
$row = mysqli_fetch_assoc($result1);
$_SESSION['value'] = $row['column_name'];

// 在第二个查询中获取SESSION中的值
$query2 = "SELECT * FROM another_table WHERE another_column = '{$_SESSION['value']}'";
$result2 = mysqli_query($connection, $query2);
// 继续处理$result2的结果

// 创建临时表并将第一个查询的结果插入到临时表中
$query1 = "CREATE TEMPORARY TABLE temp_table SELECT column_name FROM table_name WHERE condition";
mysqli_query($connection, $query1);

// 在第二个查询中使用临时表
$query2 = "SELECT * FROM another_table JOIN temp_table ON another_table.another_column = temp_table.column_name";
$result2 = mysqli_query($connection, $query2);
// 继续处理$result2的结果

// 删除临时表
$query3 = "DROP TEMPORARY TABLE IF EXISTS temp_table";
mysqli_query($connection, $query3);