如何在PySpark中将df列[JSON_Format]转换为多个列？

from pyspark.sql.functions import from_json, col
from pyspark.sql.types import StructType

df = spark.createDataFrame([(1, '{"name":"John","age":30,"city":"New York"}'),
                            (2, '{"name":"Alice","age":25,"city":"San Francisco"}'),
                            (3, '{"name":"Bob","age":35,"city":"Los Angeles"}')],
                           ["id", "JSON_Format"])

json_schema = StructType().add("name", "string").add("age", "integer").add("city", "string")

df = df.withColumn("parsed_json", from_json(col("JSON_Format"), json_schema))

df.select("id", "parsed_json.name", "parsed_json.age", "parsed_json.city").show()

+---+----+---+-------------+
| id|name|age|         city|
+---+----+---+-------------+
|  1|John| 30|     New York|
|  2|Alice| 25|San Francisco|
|  3| Bob| 35|  Los Angeles|
+---+----+---+-------------+