Probably a difficult question,) Please tell me how to change this request into elequent?

Question

SQL

SELECT posts.*, users.name,
  COUNT(comments.id) count_comments FROM posts
  LEFT JOIN users ON users.id = posts.author_id
  LEFT JOIN comments ON comments.post_id = posts.id
GROUP BY posts.id

Answer 1

First you need to create models.
https://laravel.com/docs/8.x/eloquent
Describe for relationship models
https://laravel.com/docs/8.x/eloquent-relationships
and then make requests.
Are you sure that you need exactly eloquent (i.e. work with models)? Maybe it will be enough to use query builder https://laravel.com/docs/8.x/queries#introduction ?