For the video connection, you need a USB-C (male) to Mini DisplayPort (female) adapter, or equivalent. You can find lots of these on Amazon. Do not use a Apple Thunderbolt 3-to-2 adapter – the physical connectors are the same, but it doesn't know how to speak plain DisplayPort on the TB2 side, so you wouldn't get a video signal.
https://www.amazon.com/s?k=usb-c+to+mini+displayport+female+adapter
For the USB connection, you could use one of the Mac Studio's USB-A ports.
There are also many ways to connect this (and other) USB-A (USB) accessories to your USB-C / Thunderbolt ports. One would be using an Apple USB-C to USB Adapter . Another would be through a hub or a dock with USB-A ports.
That old-style MagSafe connector is not compatible with current Mac laptops (which use MagSafe 3) – and does not have any use with a Mac Studio. You could tape something non-conducive over it, to reduce the chances of it touching something that would create a short circuit.