从SQL表创建多维数组

I have a table 'GOAL':

我有一张桌子'GOAL':

    ID   TYPE   KEY     VALUE
    --   ----   ---     -----
    1    RED    BASE    3
    2    BLUE   NAME    ALLOR
    3    RED    MAIN    _TTR
    4    GREEN  LOCAL   PIN,SEC,BALL,UNI
    5    BLUE   ALT     2DFFRST34@HH&FR#
    6    GREEN  DOMAIN  SITE.ORG,NSPL.EDU,ROAR.IN
    ID