Mysql查询AND的WHERE

id|customer_id|comment
1   34                       good
2   23                       bad
3   34                      regular
4   76                       longterm
5   34                       bad
6   23                      good

select distinct a.customer_id 
from comments a 
join comments b on a.customer_id = b.customer_id and a.id < b.id 
where a.comment = \'good\'
and b.comment = \'bad\'

a.id < b.id