如何在MySQL'insert'语句中使用'select'

I'm trying to insert additional rows into a table which requires a value to be retrieved from another table. Below is an example query:I'm trying to insert additional rows into a tab