SQL Server query - how to insert selected values into another table

Question

Here's what I am trying to do.

This is the select statement

select Id 
from tblUsersPokemons 
where UserId = 1 and PokemonPlace = 'bag'

Now I want to insert those returned Ids into another table like this:

foreach all returned Ids
   insert into tblNpcBattleUsersPokemons values (Id, 1)

How can I do that ?

Answer 1

Like this:

insert into tblNpcBattleUsersPokemons
select Id, 1 from tblUsersPokemons where UserId=1 and PokemonPlace='bag'