INSERT sql语句结合SELECT和WHERE

I am trying to insert these values into a database, however, the INSERT and WHILE clause are incompatible with each other. Does anybody have any ideas how I could achieve my desired results in a different manner. I am trying to insert these values into a datab