I don't have a specific book to recommend, but any "Level 1 Music Theory" book or course will have pretty much the same curriculum in it. At my old community college it was broken into 4 semesters of both Written (analysis) and Aural (ear training / writing by ear) Theory. Even one semester of that stuff is enough to get you through most pop / rock songwriting. Suddenly, everything you hear on the radio makes total sense, and you hear every trick there is.

-Carl.