You need to use a CASE WHEN clause.
Try this:
SELECT cid,
SUM(CASE WHEN gas=0 THEN roadl ELSE 0 END) AS b,
SUM(CASE WHEN water=0 THEN roadl ELSE 0 END) AS c,
SUM(CASE WHEN wire=0 THEN roadl ELSE 0 END) AS d,
SUM(CASE WHEN dranage=0 THEN roadl ELSE 0 END) AS a
FROM MyTable GROUP BY cid