The GameCube controller is ideal, but here is how to map FLUDD to a modern controller (Xbox/PlayStation):
If you're looking for the USA version of the game, here are some ROM details: Super Mario Sunshine Gamecube Rom Usa