SELECT a.aid,a.FK_PTID,GROUP_CONCAT( b.ptname ) AS ptname,a.Alocation FROM arequire
a LEFTJOIN projecttype b ON FIND_IN_SET(b.ptid,a.FK_PTID)
GROUP BY a.aid
SELECT a.aid,a.FK_PTID,GROUP_CONCAT( b.ptname ) AS ptname,a.Alocation FROM arequire
a LEFTGROUP BY a.aid