id        name                                score
         1        aa                                90
    1    bb                                60
    1    cc                                45
    2    aa                                45
    1    dd                                69
    2    dd                                40
           .................
想变成

     
         id      name1      name2        name3     
                   aa         bb          cc       dd
score      1       90         60           45        45
           2       45         40