insert into A (aa, bb, cc)
    select aaa, bbb, @n:=@n+1
    from AA a
    cross join ( select @n := 0 as a) c
    where 조건



ㅎㅎ