hello,

i have seen many ecommerce site where they have only one categoyry table and store all level of category with parent child id table structure is as follow

out put

how to achive this in sql the level of category can be unlimited

so it should have recursive to list down level recursively in sql

pls advice