Is the database organized correctly and is such a query effective in Laravel?

Question

Laravel

and here is the request itself - I select categories for the corresponding brands ...

public function getCategories(){

        $categories = $this->select('id', 'name')->with(['categories'=>function($query){
            $query->select('brand_id', 'name');
        }])->get();

        return $categories;
    }

Answer 1

What's the question?
You have only one category, it is difficult to spoil something, there is nothing complicated in the request.
And for zakaz_tovar, dostavka, etc. I want to hit, honestly. Is it really difficult to open google translate if you don't know the word.
Moreover, there are already orders and products, order(s)_products.