There are numerous options. Some of the books are as follows:
The Pilot's Manual Series, 2 volumes, "Ground School" and "Flight School." (my personal favorite)
Kershner's Student Pilot's Manual
The Complete Private Pilot by Bob Gardner
For video/DVD courses, the top two are:
King's Schools
Sporty's Pilot Shop
I don't think any are necessarily better or worse, just slightly different styles. Note that any of these are essentially taken from the FAA materials found in:
Airplane Flying Handbook
Pilot's Handbook of Aeronautical Knowledge
Aviation Weather
These are FAA publications, and are available online for free. They may not have as well-organized study aids like quizzes at the end of chapters, etc., as some of the other publications.
I might suggest minimal expenditure by using the FAA publications as a start, until you figure out what flight school you'll be attending, and then you can obtain whatever specific books/video materials they may prefer to use.