from(bookshelf in Bookshelf,
  join: book in Book, on bookshelf.id == book.bookshelf_id,
  group_by: bookshelf.id,
  select: %{bookshelf_id: bookshelf.id, books_count: count(book.id)}  
) |> Repo.all()