The modern Apple USB superdrive unit is for use with new models of Apple
computer that do not have a built-in optical drive. Not for older models, etc.
That seems plain enough. The MacBook series (early 2006 to 2010) all had
internal optical drives. When computers started shipping with OS X not on
DVD or CD media, then certain models who had an optical drive, didn't.
Brody's suggestion and links are a place to start. OWC macsales.com has
a few external FW optical drives and other hardware, and can give you a
fair bit of information should you contact them about the issue you face.
Older PPC portable Apple computers with PowerPC G3/G4 processors are
capable of running as late as 10.5 (.8) Leopard OS X, depending on the
processor hardware speed and other hardware requirement; not 10.6.8.
Intel-based Macs of a certain vintage may use Snow Leopard.
suggestions to use the USB optical drive with other models (not PPC)
include some comments here. re: If your MacBook superdrive fails:
https://www.ifixit.com/Device/Apple_Optical_Drive
If your newer computer happened to have FireWire ports, then the idea of
using the newer and older computers through agency of Target Disk Mode
where the new computer may (or not) be able to start in FW TDM and let
the older computer use its optical drive for use to install vintage OS X.
• How to use and troubleshoot FireWire target disk mode - Apple Support
The instruction support page linked in a previous reply does suggest how to
try & use Target Disk Mode to use a different computer superdrive for use
to install an OS X. There is a slim chance that certain models of PowerPC
(pre-intel cpu based mac) may be able to use some USB connections but
the ability to boot from external optical drives generally expects there to be
a FireWire unit with its own power supply for this kind of process. A FW unit
with compatible chipset such as oxford-type, was the historical version used.
Other methods may be possible; mostly trial and error to see if they'd work...
Since most don't, it would be pointless for me to suggest unlikely methods here.
Good luck & happy computing!