FAR 61.23 put very simply says:
ATP requires a 1st class medical
CPL is a second class
PPL is third class
Sport Pilot, Glider and Balloon either no medical or driver's license only.
Soon the U.S. Congress may make major changes to the Private Pilot rules to reduce or eliminate the required third-class medical for small single-engine airplanes.