The story
From the behavior of moths, that are instinctively attracted to light and are sometimes observed to go directly into flames, seemingly committing suicide.
Etymology from Wiktionary, CC BY-SA 4.0.
like a moth to the flame
Today it means: Inescapably allured by something harmful. Full definition →