从mysql中的字符串创建列

So what i'm trying to do left join this table that would define what a question is from the questions table and check with the responses table. I wrote the left join to define each question as its own column but its not working.. any ideas?So what i'm trying to do left join this table t