Mysql查询在两列的基础上动态地将行转换为列

I have followed a question here to use a Mysql query to dynamically convert rows to columns. This works fine, but i need to convert this on basis of two columns, here to use a Mysql