SELECT
    id,
    'A',
    BOOL_AND(answer) FILTER (WHERE username = 'A'),
    'B',
    BOOL_AND(answer) FILTER (WHERE username = 'B')
FROM
    mytable
GROUP BY id