Getting pivot table data

@furqanDev Yes but i have in category model

 public function articles()
    {
        return $this->hasMany(Article::class, 'category_id', 'id')->orderBy('published_at', 'Desc');
    }
    public function manyArticles()
    {
        return $this->belongsToMany(Article::class, 'articles_categories', 'category_id', 'article_id')
                ->using(ArticleCategory::class);
    }

i need them both but in $categoryArticles i'm getting only category_id categories not pivot table categories how can i get both?

@spAo Did you define the relationship in category model ?

@furqanDev articles() is single category relationship and manyArticles() is pivot relationship. when user is adding article he must choose single category and if he wants he can + choose multi categories. and this function works but problem is that in categories page i display only single category articles but i also want to display pivot categories.

@spAo I get your point. I'm saying that did you define pivot table reverse relation in category model ?

@furqanDev You mean article model

    public function category()
    {
        return $this->belongsTo(AllCategory::class, 'category_id', 'id');
    }

    public function manyCategories()
    {
        return $this->belongsToMany(AllCategory::class, 'articles_categories', 'article_id', 'category_id')
                ->using(ArticleCategory::class);
    }

and ArticleCategory pivot model

    public $table = 'articles_categories';

    protected $fillable = [
        'article_id', 'category_id'
    ];

    protected $guarded = ['*'];

@spAo Did you extend Pivot in ArticleCategory ?

@furqanDev yes i did

use Illuminate\Database\Eloquent\Relations\Pivot;

class ArticleCategory extends Pivot

@spAo Try loading your relation like this,

$pivot = $category->load('manyArticles')->get();

@furqanDev I'm getting All categories. but i need articles with single and multi categories in $categoryArticles variable

@spAo Check in relation if you are getting all related articles or not.

@furqanDev I'm not getting articles i'm just getting all categories only categories

@spAo Are you getting single category while fetching this ?

$category = AllCategory::bySlug($slug);

@furqanDev Yes i'm getting single category

@spAo Did you check in the relation section when you dd() ?

$pivot = $category->load('manyArticles')->get();
dd($pivot);

@furqanDev I checked with dd and i'm getting all categories from ' all_categories ' table. #relations: []

@spAo Do you have any additional condition in ArticleCategory class ?

@furqanDev no only

class ArticleCategory extends Pivot
{
    use HasFactory;

    public $table = 'articles_categories';

    protected $fillable = [
        'article_id', 'category_id'
    ];

    protected $guarded = ['*'];
}

@spAo You are over complicating a simple thing. Just go for a simple manyToMany relation between Article and Category. You can either save 0, 1 or many in pivot table. Even if you get the categories and articles you need to merge both in order to show them and make pagination. Just go for simple approach of Many to Many relation.

@furqanDev Yes but this project is already in live and single category is already used. because of it i need both of them...

@spAo Then I'd suggest you to clear some code and go for simple many to many. Don't use any pivot class as you will not be doing any additional thing. In AllCategory model

public function manyArticles()
{
	return $this->belongsToMany(Article::class);
}

In Article Model

public function manyCategories()
{
	return $this->belongsToMany(AllCategory::class);
}

@furqanDev You are saying that there is no any way to have both of them? a single category and multi?

@spAo Yes it is. I just told you to don't overwrite the code. You can simply do this. Without any pivot class since you don't have any additional methods you just go for the simple approach.

@furqanDev I'm getting to many errors... it's not a option to me... I think it's passable to have both. Okay i will continue to search. Thanks for your time : )

@furqanDev I found the way!

  $offsetPage = ($page - 1);
        $perPage = 24;
        $category = AllCategory::bySlug($slug);
        if (!$category) {
            abort(404);
        }
        $ids_from_main_category = $category->articles()->pluck('id')->toArray();
        $ids_from_pivot = $category->manyArticles()->pluck('articles.id')->toArray();
        $both_ids = array_merge($ids_from_pivot, $ids_from_main_category);
        $articles = Article::whereIn('id', $both_ids)->publishedOrder()->statusOn();
        $categoryArticles = $articles->skip($perPage * $offsetPage)->take($perPage)->get();
        $lastPage = ceil($category->articles()->count() / $perPage);

This code is doing does exactly what I wanted. : )