How to make such database record in php mysql such that A inform B,B inform C,and C inform D such that when I look at who A answer should be B,C,D?
A table like this
'name' 'inform_to'
A B
B c
C D
D Null
And you can check always recursively check till the value of column is not Null