php - Multiple line query in laravel -

i trying execute multiple line query. i'm quite new laravel. here example query.

set @sql = null;  select  group_concat(distinct      concat(       'max(if(`order` = ', `order`, ',data,null)) data', `order`)   ) @sql  tablename;   set @sql = concat('select  id, ', @sql, '                        tablename                    group   id');  prepare stmt @sql;  execute stmt; 

i trying dynamically converts columns row, that's why using multiple queries. manually write single query since there 4 unique entries in order table, become more simple. help..