Zend Jon Table , ZF2 Join table example.

TestFile.php

<?php

namespace '''''';

use Zend\Db\TableGateway\AbstractTableGateway;
use Zend\Db\Sql\Select;

class TestFile extends AbstractTableGateway
{
    public function __construct($adapter)
    {
        $this->table = 'table_name';

        $this->adapter = $adapter;

        $this->initialize();
    }

    public function Leases($poolid)
    {
        $result = $this->select(function (Select $select) use ($poolid) {
            $select
                ->columns(array(
                    'column1',
                    'column1',
                    'column1',
                    'column1'
                ))
                ->join('table2', 'table2.column1 = table1.column1', array(
                    'column',
                    'column'
                ))
                ->join('table3', 'table3.column = table1.column', array(
                    'column'
                ))
                ->join('table4', 'table4.column = table1.column', array(
                    'domain'
                ))->where->equalTo('table1.column', $value);
        });

        return $result->toArray();
    }
}