I have two tables Business and BusinessCat. I need a MSSQL Query that will get me the following result:

```
ID | CategoryName | RecordCount
1  | Local        | 3
2  | National     | 1
3  | International| 2
4  | Other        | 0

```

I need the count of how many there are in each category as another column. 

Business table looks like this:

```
ID | Category | BusinessName
1  | 3        | Blackstone, Inc.
2  | 2        | Pet Smart
3  | 1        | John Doe
4  | 3        | Best Buy
5  | 1        | Sams Treats
6  | 1        | Eastcoast Tattoo

```

BusinessCat table looks like this:

```
ID | CategoryName
1  | Local
2  | National
3  | International
4  | Other

```