You can use INSERT IGNORE INTO mysql query with the help of insertFromSelect() method in Magento 2 with use of magento best standard in your module.
Lets we have a query that use the insertFromSelect method to run a query.
Raw SQL Query to add an entry to the small_image attribute from the image attribute value.