Why the word “being” is used here?
'Being here' as in the specific situation you find yourself in. It's a very formal question.
For example, You have lost your job and are applying for financial support. You may be asked this type of question in an interview.
It is a more formal way of asking: Why do you need financial support? How has this happened?
“What are the circumstances that lead to you be here?”
You must swap 'you' and 'to'
"What are the circumstances that lead you to be here"