Join in controller method

PHP Code:

public function index()
    {

        $newsMediaModel = new NewsMediaModel();
  
        $result = $newsMediaModel->select()
            ->join('news_post', 'news_post.id = news_media.post_id', 'left')
          
            ->where(['id'=>'2'])

            ->orderBy('id','desc')
            ->paginate(10, 'default',1, 1);

        return $this->respond([
            'data' => $result,
            'pager' => $newsMediaModel->pager->getDetails()
        ], ResponseInterface::HTTP_OK, lang('Shared.api.receive'));


    } 


Enlightenment  Is  Freedom