Which is the cause, and which is the effect? It’s not easy to tell.
People with mental health problems often self-medicate with alcohol, or street drugs. (Yes, that usually only makes things worse.)
And some people with mental illness don’t drink at all.