connector cable for hard drive macbookpro 2008

A USB 3.0 to SATA interface should work. I have two in an “enclosure” form factor, but there are some that are just a bare cable and SATA connector. I actually have this one, although I primarily use it with a USB-C to USB micro-B 3.0 cable that I bought separately. I also have a Patriot Gauntlet 2.

https://www.amazon.com/Reletech-External-Enclosure-Tool-Free-Supports/dp/B08ZSDVMSP/

If a full-blown enclosure is too much for use with a temporary drive, but 'just an adapter'' is too little, the "Goldilocks - just right" solution may be a "toaster" style drive holder:

this one holds either a 2.5 or 3.5 drive at one time, but not two at once, about US$35 from OWC:

https://eshop.macsales.com/shop/NewerTech/Voyager/Hard_Drive_Dock

.