select pid,category,count(salesmount) from tbl_order where category in("空调"，“洗衣机”) group by pid,category,count(salesmount)