As far as I can think of, the INTO clause is going to have minimal perf impact. It’s just copying the result of query into an in-memory variable once at the end of running the query. So you probably wouldn’t notice any perf difference between running the query without the INTO clause and running the query with the INTO clause.
Yes, you can use INTO clause multiple times.