Why i can just showed comments for odd post? is there any logic error? pls help to fix it

Question

All. I'm facing a problem which is creating a post page like "FB" which consist of multiple post in a page. And I wrote a the controller function like this:

public function getPosts(Request $request){
        $user=User::all()->where('id',Auth::id()); //passing to input post in current.blade
        $users=User::all()->where('id',Auth::id()); //passing to data.blade which seperate file

        $posts=Content::with('comments')
        ->leftjoin('users','contents.UserID','=','users.id')
        ->leftjoin('content_attachments','contents.id','=','content_attachments.ContentID')
        ->select('contents.*','contents.id as pid','users.name','users.userAvatar','content_attachments.*')
        ->orderBy('contents.created_at', 'DESC')
        ->paginate(5);
    
        //ajax for infinite scroll
        if($request->ajax()){
            $view=view('data')->with('user',$user)->with('users',$users)->with('posts',$posts)->render();
            return response()->json(['html'=>$view]);
        }
        // dd($posts);
        return view('community')->with('user',$user)->with('users',$users)->with('posts',$posts);
    }

But the result is 1st post has comment showed 2nd post cannot display comment (no array passing) 3rd post has comment showed (but its for 2nd post) 4th post cannot display comment (no array passing) 5th post has comment showed (but its comment for 3rd post) Output: post view

Comment model:

    public function content(){
        return $this->belongsTo('App\Models\Content');
    }
    
    public function user(){
        return $this->belongsTo('App\Models\User');
    }

Content Model(post):

    public function users(){
        return $this->belongsTo('App\Models\User');
    }

    public function contentAttachment(){
        return $this->hasMany('App\Models\ContentAttachment')->withTimestamps();
    }

    public function comments(){
        return $this->hasMany('App\Models\Comment');
    }

User Model:

    public function comment(){
        return $this->hasMany('App\Models\Comment');
    }

    public function content(){
        return $this->hasMany('App\Models\Content');
    }

data.blade: which specific for post passing

@foreach($users as $users)
   @foreach($posts as $post)
      
         
            
               
               {{ \Carbon\Carbon::parse($post->ctDate)->format('d F') }}
               {{$post->ctTime}}
            
            
            
            
            
                
            
            
            

            
            
               
                  
                  {{$post->name}} 
                  18k Views
                  @if(Auth::id() == $post->UserID)
                  
                     
                     
                        
                           
                        
                     
                     
                     
                        
                           
                        
                     
                  
                  @endif
               
               
               
                   
                     {{$post->ctDetail}}
                  
                  
                  @if($post->ctImage!=NULL)
                     
                  @endif
                  
                  @if($post->ctVideo!=NULL)
                  
                     
                  
                  @endif
               
               
                  
                     
                     
                  
                  
                        
                        
                        
                        
                     
                     @if($post->likedUsers->count() !=0)
                        {{$post->likedUsers->count()+ rand(50,99)}}
                     @else
                        {{rand(50,99)}}
                     @endif
                     
                  
               
               
                  
                  @guest
                      Like
                  @else
                  
                     
                     
                     Like
                     @csrf
                  
                  @endguest

                  
                   Comment 
                  
                  
                     
                        Facebook
                        Twitter
                        LinkedIn
                        WhatsApp
                     
                      Share
                  
               
               
               
                  @foreach($post->comments as $comment)
                  
                     @if($comment->UserID == 1)   
                     
                     George
                     @elseif($comment->UserID ==2)
                     
                     Ved
                     @else
                     
                     David Lee
                     @endif
                     
                        {{$comment->cmDetail}}
                     
                     @if(Auth::id() == $comment->UserID)
                     
                        
                        
                           
                              
                           
                        
                     
                  @endif
                  
                  @endforeach
                  
                  
                  
                     
                        @CSRF
                        
                           
                           
                           
                           
                           
                           
                        
                     
                  
               
            
         
      
   @endforeach
@endforeach

Comments table in phpmyadmin: comment db

Contents table in phpmyadmin: content db

user_10888830 · Answer

instead you can do like this

$posts = Content::with('comments.user')
->orderBy('created_at', 'DESC')
->paginate(5);

as a result your comments are contained within each post object. it is much easier to loop over posts with a query like this

Why i can just showed comments for odd post? is there any logic error? pls help to fix it

1 Answers