This is my mysql query. i need to get id and count value when i passed in comma seperated id

```
SELECT tag_id AS id, COUNT( tag_id ) AS count FROM tag WHERE tag_id IN ( 1, 2, 3, 28 );

```

I get

```
---------------
| id  | count |
---------------
|  1  |  4    |
---------------

```

Expected result is:

```
----------------
|  id  | count |
----------------
|  1   |  2    |
|  2   |  1    |
|  3   |  5    |
| 28   |  0    |
----------------

```

Pls help....