I have two tables `table1` and `table2`:

**table1:** 

```
id (primary key)
name
email
category1 (foreign key to table2.id)
category2 (foreign key to table2.id)
category3 (foreign key to table2.id)

```

**table2: (categories)**

```
id (primary key)
name

```

I want to write a select query to get the category names instead of the categoryId.