The PS3 itself is a single-console, single-screen device—you can't have two players on one controller. However, several multiplayer modes exist:
You can play two-player on PS3—just not with a single controller. Grab a second DualShock 3, pick a split-screen or co-op game, and enjoy.