Sorting categories / subcategories in MI. How to do it right?

Question

PHP

There is a database with the goods of the online store. Products are divided into categories/subcategories. From this data, the side menu and product lists are formed.
How to sort categories/subcategories/products not in sequence as they are listed in the database and not alphabetically, but as I need (there are more important categories/subcategories/products that need to be shown at the top of the list)?
The only thing I came up with was to add weights to the database and sort by weight ...
Are there more correct approaches?

Answer 1

Add an order field and sort by it