1.app_tenant pk:id, fk:pasar_id
 ---+--------+-----------+
 id | nama   | pasar_id  |
----+--------+-----------+
  1 | joe    |         1 |
  2 | adi    |         2 |
  3 | adam   |         3 |

2.app_pasar pk:id
----+------------- +
 id | nama         |
----+------------- +
  1 | kosambi      |
  2 | gede bage    |
  3 | pasar minggu |


 3.app_kios pk:id, fk:tenant_id
----+---------------+----------
 id | nama          |tenant_id
----+-------------- +----------
 1  | kios1         |1
 2  | kios2         |2
 3  | kios3         |3
 4  | kios4         |1
 5  | kios5         |1
 6  | kios6         |2
 7  | kios7         |2
 8  | kios8         |3
 9  | kios9         |3

----+---------------+------------+-----------
 id | nama_tenant   |nama_pasar  |nama_kios
----+-------------- +------------------------
  1 | joe           |kosambi     |kios 1
  2 | adi           |gede bage   |kios 2
  2 | adam          |pasar minggu|kios 3

select a.id,a.nama as nama_tenant,
       b.nama as nama_pasar,
       c.nama as nama_kios
from app_tenant a
left join app_pasar b on a.id=b.id
left join app_kios c on a.id= c.tenant_id
group by
      a.id,
      b.id,
      c.id

CREATE TABLE app_tenant (
  id serial PRIMARY KEY,
  nama character varying,
  pasar_id integer);

CREATE TABLE app_kios (
  id serial PRIMARY KEY,
  nama character varying,
  tenant_id integer REFERENCES app_tenant);

SELECT t.id, t.nama AS nama_tenant, p.nama AS nama_pasar, k.nama AS nama_kios
FROM app_tenant t
LEFT JOIN app_pasar p ON p.id = t.pasar_id
LEFT JOIN (
  SELECT tenant_id, first_value(nama) OVER (PARTITION BY tenant_id ORDER BY nama) AS nama
  FROM app_kios) k ON k.tenant_id = t.id
ORDER BY t.id