SQL如何使用唯一ID及其关系条目复制主记录

I have two tables, a master table and a relation table. The Master table as an automatic identity ID field (DOCUMENT_ID) that is generated upon insert. The relation table ties that DOCUMENT_ID from the master table with a USER_NAME entry. I want to be able to create a copy of the the record in the master table and a copy of its relation in the relationship table while establishing the new relation using the new automatically generated DOCUMENT_ID generated by the Master table. Here is an example of my tables and the desired output. I have two tables, a master table and a relatio