i have this two tables

**Table 1: "Identity"**

```
ID | identifier | report_ids
------------------------------
1  | TOP        | ["1","2"]

```

***The "report\_ids" is a VARCHAR column, not JSON***

**Table 2: "Reports"**

```
ID | name
------------------------------
1  | Report Food
2  | Report Beverage

```

I have to select from table Identity and Join the table Reports to get the names by his ids

in summary, i hope to have this result with a query:

```
Result:
ID | identifier | report_names
--------------------------------
1  | TOP        | Report Food, Report Beverage

```

How i can do this with Query?

Thanks in advance at all :)