SQL Group by Count String occurance

I am wanting to count the occurrences of a specific string in SQL.
I have UserID’s which are unique and each user can carry out an "action". I’ve tried a few things but still cannot get it to work.

So these actions can be "throw" "pickup" "craft"

SELECT userid, COUNT(action)
FROM `playeractions`
GROUP BY action;

Expected results required

Existing data of the table

>Solution :

you can simple privot the data

SELECT
    userid,
    SUM(action = 'throw') as 'throw',
    SUM(action = 'pickup') as 'pickup',
    SUM(action = 'craft') as 'craft'
FROM table1
GROUP BY userid