mysql 两列计数_MySQL多重计数基于两列与单个表中的多个GROUP BY

我有一个像下面的查询，它工作正常，但没有优化，因为它需要1.5秒的运行。如何使这个优化结果？

select h.keyword_id,

( select count(DISTINCT(user_id)) from history where category_id = 6

and h.keyword_id=keyword_id group by keyword_id ) as cat_6,

( select count(DISTINCT(user_id)) from history where category_id = 7

and h.keyword_id = keyword_id group by keyword_id ) as cat_7

from

history h group by h.keyword_id历史表

his_id keyword_id category_id user_id

1 1 6 12

2 1 6 12

3 1 7 12

4 1 7 12

5 2 6 13

6 2 6 13

7 2 7 13

8 3 6 13结果：

keyword_id cat_6 cat_7

1 2 2 (unique users)

2 2 1

3 1 0