select distinct p_ID,
sum(if(s_id='01',p_Num,0)) as s1_id,
sum(if(s_id='02',p_Num,0)) as s2_id,
sum(if(s_id='03',p_Num,0)) as s3_id
 from A
 group by p_ID
 order by p_ID;