Extracting two particular values from a multi valued column
If you don't need the extra commas, then:

SELECT CONCAT(id, ',',
          GROUP_CONCAT(bars ORDER BY bars))
    FROM subscriber
    WHERE bars IN ('bar1', 'bar4')
    GROUP BY id;


If you do need the commas, then search for "pivoting".