从一个表查出数据插入新表中

INSERT INTO  目标表 (字段1, 字段2, ...)  SELECT   字段1, 字段2, ...   FROM  来源表 ;
 
INSERT INTO TPerson ( UserId, DepId )
SELECT UserId,DepId FROM TUser WHERE 'Status' = 0;