如何在pyspark中按列合并多个数据帧？

from pyspark.sql import SparkSession
from pyspark.sql.functions import col

spark = SparkSession.builder.getOrCreate()

df1 = spark.createDataFrame([(1, 'A'), (2, 'B'), (3, 'C')], ['id', 'col1'])
df2 = spark.createDataFrame([(1, 'X'), (2, 'Y'), (3, 'Z')], ['id', 'col2'])
df3 = spark.createDataFrame([(1, 'M'), (2, 'N'), (3, 'O')], ['id', 'col3'])

merged_df = df1.join(df2, 'id').join(df3, 'id')

selected_df = merged_df.select(col('id'), col('col1'), col('col2'), col('col3'))