选择查询获取表中的行作为MySQL中的列

I have a MySQL database with two tables for questions and answers. Each question has a correct answer and three incorrect answers. There are always four answers for every question and only one is correct. I have a MySQL database with two tables for que