mIRC does have an internal player and the command is /splay. While it doesn't support CDA, it supports MP3 and WAV (don't know about other formats).
Unless you're talking about a player that also advertises into the channel what you are listening to, in which case that won't appear in vanilla mIRC. If you want that, you're gonna have to script it.
