Cannot handle self referencing table

[ree-grestark]

I have a table which has a self referencing column, let say the table is brands and it has brands child (reference to same table)

With the query method i cant do JOIN (sql state: 42712) the table specified more than once

Is there a way to get the relation on same table?