fname       ftype             fvalue小喬        zaocan              10小喬       zhongcan             20小喬        wancan               5

fname       zaocan_value          zhongcan_value       wancan_value小喬           10                     20                    5

select Fname, sum(case Ftype when 'zaocan' then Fvalue else 0 end) as zaocan_value,sum(case Ftype when 'zhongcan' then Fvalue else 0 end) as zhongcan_value,sum(case Ftype when 'wancan' then Fvalue else 0 end) as wancan_value from case_table group by Fname