如何将数据插入到包含有外键依赖关系的多个表中(MySQL)

I am looking for the best-practice way to insert data to multiple MySQL tables where some columns are foreign key dependencies. Here is an example:I am looking for the best-practice way to inser