To use your own mp3's, you need to copy the mp3 file to:
My Documents\EA Games\The Sims 2\Music\[subfolder]\
The subfolder will be either the type of music station or the buy or build mode. If your music does not play right away in the game through the radio, you can have your Sim skip the song.