Hi, I have a question about join method.
// relationship definition in Article::initialize() $this->belongsTo( 'user_id', User::class, 'id', [ 'alias' => 'a', 'reusable' => false, ] );
$userWithArticles = User::query()->innerJoin( Article::class, "User.id = a.user_id", // conditions "a" // alias )->execute();
this code executes SQL just like below.
SELECT `users`.`id`, `users`.`name` # articles table's columns are not included!! FROM `users` INNER JOIN `articles` AS `a` ON `users`.`id` = `a`.`user_id`
I also would like to fetch from
articles table's columns are not included in SELECT.
What should I do to fetch
articles table's columns?
Or, please tell me how to solve N+1 problem.