Gorm How to use Automigrate to merge two tables into one

Your Question

I have two tables in the database, and I want to run a migration to merge those two tables into one. For now, I read two tables into memory and then insert each row into the third table. I want to know if there is a best practice to do that.

Expected answer

It would be great if anyone can share an example