Pretty much any optical drive out there should be compatible and work fine. There is no specific brand or type for this. It's a universal standard now.
Known brand include Asus, Dell and HP. Make sure it's connected directly to the Mac via a proper adapter, or using an externally powered USB hub. Non-powered hubs and cheap adapters are known to cause issues.
Some examples:
click here ➜ Asus ZenDrive 8X DVD Drive - Amazon.com
click here ➜ Dell Slim DVD+-RW DVD Writer - Amazon.com
click here ➜ HP DVD RW - Amazon.com
click here ➜ Ugreen USB-A to USB-C Adapter (2-pack) - Amazon.com