Super Mario 64 Multiplayer is a ROM hack/mod of Super Mario 64 which adds multiplayer support for the original game. It can also be added to many other mods.
It shouldn't be confused with Super Mario 64 Splitscreen Multiplayer, the former doesn't make the game splitscreen, both players share the same screen.