Gsyfuy

i'm doing crud module for children and parent table. Can anyone suggest how to get the data from parent table.
Many thanks
here are may table

namespace ThuyNTCrudSetup;
use MagentoFrameworkDBDdlTable;
use MagentoFrameworkDBAdapterAdapterInterface;
use MagentoFrameworkSetupInstallSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;

class InstallSchema implements InstallSchemaInterface
{

public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)



{

    $installer = $setup;

    $installer->startSetup();

//
$table = $installer->getConnection()
->newTable($installer->getTable('crud_news_post'));
$table->addColumn(
'entity_id',
Table::TYPE_INTEGER,
null,
[
'identity' => true,
'unsigned' => true,
'nullable' => false,
'primary' => true
],
'Post ID'
)
->addColumn(
'authorpost_id',
Table::TYPE_INTEGER,
null,
[
'unsigned' => true,

            ],

            'Post Author ID'

        )

        ->addColumn(

            'title',

            Table::TYPE_TEXT,

            255,

            ['nullable' => false,],

            'Post Title'

        )

        ->addColumn(

            'url_key',

            Table::TYPE_TEXT,

            255,

            [],

            'Post Url Key'

        )

        ->addColumn(

            'post_content',

            Table::TYPE_TEXT,

            '64k',

            [],

            'Post Content'

        )

        ->addColumn(

            'type',

            Table::TYPE_TEXT,

            '64k',

            [],

            'Post Type'

        )

        ->addColumn(

            'is_active',

            Table::TYPE_INTEGER,

            null,

            [

                'nullable' => false,

                'default' => '1',

            ],

            'Is Author Active'

        )

        ->addColumn(

            'updated_at',

            Table::TYPE_TIMESTAMP,

            null,

            [],

            'Update at'

        )

        ->addColumn(

            'created_at',

            Table::TYPE_TIMESTAMP,

            null,

            [],

            'Creation Time'

        )->addForeignKey(

            $installer->getFkName('crud_news_post', 'authorpost_id', 'crud_news_author', 'author_id'),

            'authorpost_id',

            $installer->getTable('crud_news_author'),

            'author_id',

            Table::ACTION_CASCADE)

        ->setComment('News posts');

    // $installer->getConnection()->createTable($table);

// $installer->getConnection()->addIndex(
// $installer->getTable('crud_news_post'),
// $setup->getIdxName(
// $installer->getTable('crud_news_post'),
// ['name', 'url_key', 'post_content'],
// AdapterInterface::INDEX_TYPE_FULLTEXT
// ),
// [
// 'name',
//
// 'url_key',
// 'post_content',
//
// ],
// AdapterInterface::INDEX_TYPE_FULLTEXT
// );
$installer->getConnection()->createTable($table);

    $table = $installer->getConnection()

        ->newTable($installer->getTable('crud_news_author'));

    $table->addColumn(

        'author_id',

        Table::TYPE_INTEGER,

        null,

        [

            'unsigned' => true,

            "nullable"=>false,

            'primary' =>true,



        ],

        'Author ID'

    )

        ->addColumn(

            'author_name',

            Table::TYPE_TEXT,

            255,

            ['nullable' => false],



            'Author Name'

        )

// ->addIndex(
// $installer->getIdxName('crud_news_author', ['author_name']),
// ['author_name']
// )

        ->setComment('Author To Link Table');

    $installer->getConnection()->createTable($table);

    $installer->endSetup();

}

}