How, when querying three tables, to conclude where the values ​​of the second table are the names of the columns?

Question

MySQL

The essence of this
is there are three tables - a list of clients, a list of questions, answers are
stored something like this
{clients}
id, name
{questions}
id, question
{answers}
clientid, answerid,questionid,answer
Here I want to draw a conclusion so that it looks like this
[id client], [client name], [question 1], [question 2], [question 3], ...
[1],[Andrew],[answer 1],[answer 2],[answer 3],. ..
I'm breaking my head how to do it using mysql and it's easy. an option comes to mind, but a head-on option and a long and difficult to modify later, tk. The list and order of questions may change...

Answer 1

I don't see any connection between question and answer. You need to add more questions id to the answer table.
The request will be like this
The output will be like this

1 Андрей Вопрос1 Ответ 1
1 Андрей Вопрос1 Ответ 2
1 Андрей Вопрос1 Ответ 3