I would highly recommend How Music Works by John Powell. I've been playing piano since I was a kid, but, being technical, having music explained in scientific terms was the one thing that really upped my game. Everything before this book always seemed like religious teaching and I could never really find a place for the knowledge to hang on to in my mind.
There's also a book with the same name by David Byrne, but I can't comment on that one.
The David Byrne book is great but it doesn't cover music theory. It covers music in general with a focus on how the music industry works. I highly recommend it but it will not teach music theory.
There's also a book with the same name by David Byrne, but I can't comment on that one.