Becoming a Manager by Linda Hill. Not a how-to, but it gives you a preview of the challenge and the blind spots you might have as you become a manager.

Another that I haven't read but has been recommended to me is The Manager's Path.

This article is also good: https://charity.wtf/2019/01/04/engineering-management-the-pe...