Create new child records based on a parent table report

Yes, so if Employee A was assigned to Organization Z (who has Site 1, Site 2, and Site 3 Child records), I want to programmatically add additonally assignment records for all the sites under Organization Z.

So If A->Z
      then A->1
              A->2
              A->3 records should be generated.