Full post coming soon — I'll walk through a real MYS_Password_Generator class I fixed that had a SOQL query inside a for-loop, explain the governor limit math, and show the refactored pattern using Maps and bulk queries.
⚡ This is one of the most common Apex anti-patterns I see in orgs. The fix is always the same — get your data before you loop, not inside it.