I don't have specific recommendations, but because managers are everywhere. I'd just ask around to people you know and see if they like their manager. You'll usually find one or two people who are liked by a large number of people. Then I'd save up about $5 and invite that person for coffee and ask them their story on how they got into management. If they do have a book to recommend, go with their recommendation.
The reason for recommending a relationship over a book is because management is really all about people. Some management styles will work in some industries, but be completely useless in others. Sometimes a management style is good for some people and not others.
If you really have no idea where to start, I'd recommend Dale Carnegie's "How To Win Friends and Influence People". Sorry that it's not hip, current, or trendy but people have pretty much been version 1.0 for many thousands of years now. Besides, it was first published in 1936 and is still being published. If you're cheap, just read the wikipedia page: https://en.wikipedia.org/wiki/How_to_Win_Friends_and_Influen...
Their podcast, Manager Tools, is also excellent.
Everything in the book is based by longitudinal surveys done over several decades everywhere from Burger King to the Army to tech companies.
https://www.amazon.co.uk/Peopleware-Productive-Projects-Tom-...
Worth its weight in gold.